Skip to main content
Question

URL for current time in Time of Day field

  • June 23, 2026
  • 0 replies
  • 108 views
Forum|alt.badge.img+2

Hey all,

Trying to deal with stamping a Time of Day field with the current time when clicking a button. I know about how "now" functions to do this properly when using a Date/Time field, but it doesn't seem to translate properly into Time of Day fields. It errors if I just try to use "now" in the field assignment and returns nothing if I ToTimeofDay("now").

I can't use Now() because this caches the time the page loads and that won't work for how this process needs to function.

What's my best option to get this handled?

    KellyHayes
    Forum|alt.badge.img+3
    • KellyHayes
    • Registered
    • June 23, 2026

    Could you create a helper date/time field, have your button populate that with the current date/time using "now", and then have your Time of Day field be a formula that just reflects what's in the date/time field - ToTimeOfDay([My Date/Time Field]). It sounds like maybe your users won't need to manually populate the time of day, since it's done via the button. Or am I not understanding your process?

    Forum|alt.badge.img+2
    • VARCSolutions
    • Author
    • Registered
    • June 23, 2026

    No, you're right, but it does have the option of manual override as well. I could just go date/time but they've given pushback on not wanting both to be changeable. I thought about having another set of date/time fields that stamp from "now" in the button and a formula to grab the time from that to run a pipeline over to stamp onto the manual Time of Day fields but that all feels very overkill for what this should be doing.

    RoyWanyoike
    Forum|alt.badge.img+13
    • RoyWanyoike
    • Registered
    • June 24, 2026

    How about you change your field to Date/Time (instead of pure Time of Day) if possible. Date/Time fields handle Now () perfectly, and you can display only the time portion on forms/reports using formatting.

    Going your way I think if you're concerned on the exact time of the day then opt for a pipeline which will be listening from a checkbox and when there's is a flip of state. It captures the exact time and then send an update. This way you can capture realtime without being affected by page loads and cache.

    Roy Wanyoike
    Terms & ConditionsAccessibility statement