I am using the Get(CurrentTime) function in a script and when it executes it returns the time "1/1/0001 12:00AM" - has anyone seen this before?
The script is rather straight forward:
Set Field [ VisitDetails::DateTimeOut ; VisitDetails::DateTimeOut = Get (CurrentTime) ]
The field is of type TimeStamp. I tried Get(CurrentTimeStamp) and that didn't work either - same value returned
I am not sure if I am missing something or if there is a conversion I need to do?
As an FYI - I have a field in the layout (same table as the script interacts with) that gets the current time using the "Auto-Enter" option set and that is working correctly. When I add a new record the correct system time is captured in the field. (this is a different field from the one using the script.)
Lastly the script is called by a button - when the visitor checks out - you tap a button and the time should be recorded with date.
Any insight would be greatly appreciated.