Confusing query - Criteria to only display current bookinds.

[mr_sd]

I have a query which displays times of bookings for today.

Booking times are formatted in 24hr clock without seconds eg "14:00"

I need a criteria which will only display bookings up to 2 hours old so at 16:00 the 14:00 booking will no longer display.

I have tried (in the booking time criteria)

>Dateadd("h",-2,[Game1Start])

But then I realised it's maybe because the time is formatted wrong, so I tried this:

>Dateadd("h",-2,(Format([Game1Start] "Short Time")))

Still no joy

Any ideas?

 

[aleb]

try this:
>FormatDateTime(Now(),4)

 

[mr_sd]

Sorted

Thank you.