Logical calculation based on [Date/Time] Column

[Lou Reyes]

One of the columns that's imported into my table is a Date/Time column in the format "5/17/2019 9:40:01 AM".

I'm trying to create a calculated column that would stamp 'First stage', 'Second stage', 'Third stage' based on key time markers at 10:15 AM, 12:30 PM, and 2:45 PM.

Have not been able to create a formula to achieve it... and when trying the functions Hour in combination with Minute... typically restricts it toa fixed hour slot.

 

I thoughtthis was an easy task... but I seem to be overlooking something.

Any thoughts are much appreciated!

Lou

[Gaia Paolini]

you surround your date column and the cutoff with Time(..). Then use a case statement.

Something like

case

when (Time([Mydate])>Time("10:30")) and (Time([Mydate])=Time("12:30")) and (Time([Mydate])=Time("14:45")) or (Time([Mydate])