Skip to main content

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

  1. Specify your Output Language. Use the dropdown to choose the language of the output. Currently, only English is supported.

  2. 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

In this section: