my Order Date field looks something like this:
as you can see it contains both date and time in same field.
I wish to use something like this
If((Time(Frac([Order Date]))>=Time('17:00:00') AND Time(Frac([OrderDate]))<=Time('08:00:00')), 'Night', 'Day')
but I cant seem to get it to work. filter just shows 'Day' and it does not seem to link to anything.