4 Replies Latest reply on Feb 23, 2015 7:26 AM by MT_2

    Date calculation on creating a New Record

    MT_2

      Title

      Date calculation on creating a New Record

      Post

      Hi,

       

      I want to create a field that on creation of a new record works out if to insert todays date or tomorrows date.

      If the record is created before 17:00 I want it to insert todays date if after 17:00 I would like it to insert tomorrows date.

      I was writing something like this

      in  Database - Field is called "Workflow date"

      Options - Auto-Enter - Calculated value

      get(current time)<="17:00" ; (current date);(currentdate)+1

      but its not working and I am not used to calculation like this so I would appreciate anyones help

      Thanks

      MT