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.