I’m new to Knack and working with the Next Gen Builder. I’ve read what I can find about the Timer data type, but I’d like to see some “technical” info about it. For example, what info is actually stored in that thing and how can we access the various components? I can get that bizzarro formatted display “10/01/2025 09:30 to 10:45 = 1.25 hours” and I can get the elapsed time in a variety of units, but I have a need to retrieve the DATE part of either the From or the To component. Any help would be greatly appreciated, even JavaScript, but it must be REACT JavaScript!
With some help from Copilot AI, I created a NO CODE SOLUTION, but it’s very crude!
(1) Open the table that contains your timer field.
(2) Add a new text formula field with the value trim(left({Your Timer},14)) (I tried 10, which makes more sense and is what AI recommended, but you’ll need to use 14)
(3) Add a new date field (i.e. {From Date})
(4) Add a new conditional rule to the table that sets the value of {From Date} to the text formula field you created in (1), above. The rule should run with every record. I couldn’t find a Knack Next-Gen function to convert a string to a date, but the conditional rule seems to figure it out.
This new From Date field can now be used to drive calendars or any place you need just the From date from the timer field.
Hi Richard
Instead, it might be easier to use 2 date time fields being Start Date/Time & End Date/Time, an equation to calculate the elapsed time, and then 1 more equation field to extract the date from the Date/Time field like this.
Dean
Thanks for the suggestion! I started with that but didn’t like having to select the (same) date twice, once for start and again for end. At least with the Timer data type, I can just tab through the second date.