AnsweredAssumed Answered

A Question about Time Formatting

Question asked by tcwaters on Oct 30, 2018
Latest reply on Oct 30, 2018 by philmodjunk

I'm working on a solution where there are three time fields, "Registration Time Opens" "Event Start" and "Event End" and a script that uses get(CurrentTime) to either allow access or disallow access.  and I was testing out if there is a space before the time period or not.  In other words, is 2:30PM = 2:30 PM.


It seems to me that FileMaker can look at 2:30PM and see that it is the same as 2:30 PM.   And if Get(CurrentTime) is 3:01 PM, it can correctly compare a field with either 3:00PM or 3:00 PM.  In this case, it would know that the current time is later than the field.  Do I have this correct?


I've been sitting here playing with a test DB and a few fields, and just want to make sure I haven't missed anything.