Set Current Time?

Question

I believe

Today() is used for the current date.
Now() is used for the current date and time
What do you use for ONLY the time? To set the time of day field to the current time?

------------------------------
Mike Tamoush
------------------------------

markshnier__you · Accepted Answer

ToTimeOfDay(Now())------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

miketamoush · Answer

Do you know of there is a syntax in formula apis such as:

"&_fid_7=now" or "&_fid_7=today"

Is there the equivalent for time?

Or would it be: "&_fid_7=" & URLEncode(ToTimeOfDay(Now()));

------------------------------
Mike Tamoush
------------------------------

markshnier__you · Answer

This is valid and he field will be populated with the date/time that the button was clicked.
"&_fid_7=now"

This will populate the date/time that the page loaded, so typically better to use the above.
"&_fid_7=" & ToText(Now())

This is not valid
"&_fid_7=today" it has to be

"&_fid_7=" & ToText(Today())

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------

miketamoush · Answer

Meant to tell you Mark -&nbsp;I tested "&amp;_fid_7=today" to fill in a date field, and it worked. I have also used "&amp;_fid_7"= URLEncode(Today()) which worked as well. I am not sure if the first one fills in the date of the button push (which would only matter if it was pushed at 11:59:59.59999pm).&nbsp;------------------------------Mike Tamoush------------------------------

Forum Discussion

Set Current Time?

4 Replies