Time is a Date/Time value formated as "time" (example 9:00:00 AM)
I'm trying to filter out values before 9 am and after 6pm. Not hitting the right operands to accomplish even a unique time value:
I've tried Time="9:00:00 AM" and Time .In.("9:00:00 AM")
what am I missing?
You can compare dates/times against string expressions using two handy functions: dtoc and ctod (date to character and character to date).
In your case, Hour()<9 .and. Hour()>5 should also work.
Retrieving data ...