IF statement syntax

[amandacastro]

I am basically trying to use the "BETWEEN" operator within the IF statements. Could you please advise with some examples? Thanks!

E.g., if I have times and a column named [32] where [32] is basically times, like 7:59, 16:00 and if < 7:59 AM then it is morning and if from 16:00 to 18:00 it is evening? This is what I have tried but not working

[Qiu · Accepted solution]

@amandacastro 
First, make sure it is in Time Format

Then you have to use quote for your critia.

[amandacastro]

How can I handle these following cases, when the time has some whitespaces in front?

I have selected the 

options above but it still doesn't get rid of something like:

'7:16' vs. '17:20'

Where '7:16' is recognized as morning and '17:20' is throwing an error

[Qiu]

@amandacastro 
If you have mentioend me, I would have noticed earlier.😁
Can you give some details or snaptshot?

Based my understanding and test, it still works.