AnsweredAssumed Answered

IF Statement from Dates and Times

Question asked by Penny on Sep 14, 2017
Latest reply on Sep 15, 2017 by Orlando

Hi everyone

 

I have a Creation Time and Creation Date field for each record and want to determine a Session Number for a conference for each record based on those times and dates.

 

I started to put together an IF statement but wasn't sure how to represent the time. For example if the time for Session 1 is 28/09/17 and between 9AM and 12Noon, Session 2 is 28/9/17 between 1PM and 4PM, Session 3 is 29/9/17 between 9.30AM and 12:30PM etc.

 

Any help in how to write the IF calculation? or is there a better way?

 

Thanks

Outcomes