AnsweredAssumed Answered

Date calculation on creating a New Record

Question asked by MT_2 on Feb 23, 2015
Latest reply on Feb 23, 2015 by 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

Outcomes