IF statement syntax

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

Developer Tools

Accepted answers

@amandacastro
First, make sure it is in Time Format

Then you have to use quote for your critia.

1207-amandacastro.yxmd

All comments

@amandacastro
First, make sure it is in Time Format

Then you have to use quote for your critia.

1207-amandacastro.yxmd

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

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703