Query Formatting Based On Date (1 Viewer)

[Tor_Fey]

Good Morning All;

I am need help in formatting a MS Access 2016 query based on time of day, so for example:

if hour ([CreatedDate]) is in [8 to 17.30] then "Daytime" else "Nighttime"

How can i write this in the criteria of my query?

Kind Regards
Tor Fey

 

[arnelgp]

Expr1: Switch(CDbl([CreatedDate])<=0.729166666666667 , "Daytime", True, "Nighttime")

 

[Gasman]

Hour() will return an hour no minutes.
Try using TimeValue() function and either > and < or Between keyword

https://support.microsoft.com/en-us/office/timevalue-function-0b615c12-33d8-4431-bf3d-f3eb6d186645