Skip to Content
0
Former Member
Jan 19, 2016 at 05:19 PM

Select Records in Date and Time

16 Views

I am looking for some help creating an if then formula. My current formula is below.

IF({DATETIME}) in DATETIME (2014, 01, 01, 12, 00, 00) to DATETIME (2014, 01, 31, 23, 59, 59) then 1 else 0

I really want it to evaluate if {DATETIME} is between 01/01/2014 to 12/31/2015 AND if it is between the time of 9:30 AM to 1:00 PM. I am struggling with how to