DateTimeNow Tool
Use DateTimeNow to return a single row: the date and time at the workflow runtime, and convert the value into the string format of your choosing. This is a useful tool to add a date-time header for a report, for example. Note that the output is in Coordinated Universal Time (UTC).
Tip
This tool has a One Tool Example. Visit Access Sample Workflows to learn how to access this and many other examples directly in Designer Cloud.
Configure the Tool
Specify your Output Language.
Note
Currently, only English is supported for the Output Language.
Select the Output Format to specify the string format for the date-time value returned. The available output format options depend on the selected language.
HH:mm:ss
day, dd Month, yyyy
dd-MM-yy
dd-MM-yyyy
dd-Mon.-yy
dd Month, yyyy
dd/MM/yy
dd/MM/yyyy
dy., Month dd, yyyy
MM-dd-yy
MM-dd-yyyy
MM/dd/yy
MM/dd/yyyy
Mon dd
Month dd, yyyy
Month, yyyy
yyyy-MM-dd
yyyyMMdd
yyyy-MM-dd hh:mm:ss
MM/dd/yyyy hh:mm:ss
MM/dd/yy hh:mm:ss
dd/MM/yyyy hh:mm:ss
dd/MM/yy hh:mm:ss