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
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    2 years ago
    ToTimeOfDay(Now())

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

4 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew #1 Challenger
    2 years ago
    ToTimeOfDay(Now())

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

      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
        Qrew #1 Challenger
        11 months ago

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