Forum Discussion

MikeTamoush's avatar
MikeTamoush
Qrew Commander
2 years ago
Solved

Set Current Time?

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
------------------------------
  • ToTimeOfDay(Now())

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

4 Replies

  • ToTimeOfDay(Now())

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • MikeTamoush's avatar
      MikeTamoush
      Qrew Commander

      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's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend

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