Testing a Time of Day field against Now()
I am trying to test whether the time set in a time of day field is greater than or equal to the time now. I am getting an error that says >= can't be used on a time of day field. So what do you use ...
Forum Discussion
Now is a date/time field - while it sounds like your [Start Time] is just a true time of day field?
If so - you need to first pluck out the Time of day from Now() in order to compare like:
[Start Time] >= ToTimeOfDay(Now())
------------------------------
Chayce Duncan
------------------------------
That was it! You are a genius!
------------------------------
Julie Meeker
------------------------------
