Hi. I'm not sure if the best way to approach this but here is what I'm trying to do. I want to record the first time someone captures times in my app. From there, I want to compare the current time to the start time and flag it after it hits certain breakpoints.
1) Identify the first time entry.
2) Convert it to a number (StartTime)
3) Convert now() to a number (CurTime)
4) Set my message visible to If(CurTime-StartTime>4.05,true,false)
Here is what I've done:
- I can identify the start time by creating a gallery filtered using FirstTime. This gives me my start time.
- I set up a timer to refresh my now() every second to ensure my current time is always up to date
I'm thinking I might be able to do Value(Now()) - Value(Today()) to get the numerical value of the time. However, I'm not sure how to convert that into something useable.
