All Records Up to a certain time

[keeno]

Hello

I am trying to create a formula which will return me any records with a (Reported Date) up to 08:00am on the previous day.

Can someone help me write this formula

Many Thanks

David

 

[lbass]

Is this related to your question in thread767-1209320? Try:

{table.datetime} < datetime(currentdate-1,time(8,0,0)))

-LB

 

[lbass]

Sorry, that should have been: thread767-1208320, and in that thread the formula could have been simplified to

{table.datetime} in datetime(currentdate-1,time(8,0,0))) to
datetime(currentdate,time(7,59,59))

-LB