Search the Community
Showing results for tags 'system date'.
Hello, Does anyone know how to get and use the system date/time (the local computer's date/time and not a UTC value) in a table's triggered actions, and then use it? I have a table that logs activity from other tables and need to be able to log the user's local system date/time upon insert. The function SysDateTime() isn't available in a table's formula field and I'm not sure how/if I can use SysDateTime() to populate a date/time field in the table upon insert. In the Activity table's Upon Insert trigger, it would be something like a date/time field: Created_Local=SysDateTime() in t