Testing a Time of Day field against Now()

Question

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 to test if the Start Time is Greater than Now()?

------------------------------
Julie Meeker
------------------------------

chayceduncan · Answer

Now is a date/time field - while it sounds like your [Start Time] is just a true time of day field?&nbsp;

If so - you need to first pluck out the Time of day from Now() in order to compare like:&nbsp;

[Start Time] &gt;= ToTimeOfDay(Now())
------------------------------Chayce Duncan------------------------------

juliemeeker · Answer

That was it!&nbsp; You are a genius!&nbsp;------------------------------Julie Meeker------------------------------

Forum Discussion

Testing a Time of Day field against Now()

Related Content

Let's Test the Email Notifications

Test

Testing Notifications

Test As Role URLs?

test

Recent Discussions

Pipeline Error --> "Quickbase reported an error: No error"

View query record if single record otherwise view query list

How do I unhide an app that I have no idea what it is named?

Gnatt plugin

Justifications for Table Report Columns