AnsweredAssumed Answered

How to determine whether its a day/night shift from date-time

Question asked by KatherineShier on Oct 16, 2017
Latest reply on Oct 17, 2017 by KatherineShier



I'm capturing the date-time(decimal-date-time(now())) for a survey and want to use this to determine whether this falls in the day or night shift. The day shift would be 6am-6pm and night shift 6pm-6am.


I'm thinking I'll need to capture the time, format it and then do an if statement. I'm not sure of the best time format to use along with the appropriate if statement. I have attached an extract of the form of what I have so far.


Many thanks