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.
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. Use the dropdown to choose the language of the output. Currently, only English is supported.
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.
Note
Currently, only English is supported for the Output Language.
DateTime Format
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