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()

2 Replies

Related Content

An API(?) button to copy fields from the form, to other fields

Impersonate User Permissions - Test as another user

Multiple reference proxy fields help

Custom Data Rules testing for Unique

Pipeline Make Request - Return Make Request JSON Output into fields

Recent Discussions

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

Quickbase JMP connection