Skip to main content

Date Time Now Tool Icon Date Time Now Tool

One Tool Example

Date Time Now has a One Tool Example. Go to Sample Workflows to learn how to access this and many other examples directly in Alteryx Designer.

Use Date Time Now to return a single record: 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.

*New in 2025.1 Release

The Date Time Now tool output uses your system time zone or the time zone specified in the Workflow Configuration Runtime settings.

Configure the Tool

  1. Specify your DateTime Language: Select the dropdown to choose the language of the output. The language that you select determines the options available in the Output Format dropdown.

  2. Output Format: Select the dropdown to choose the string format for the date-time value returned. The available output format options depend on the selected language.

English

  • 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

简体中文 (Simplified Chinese)

  • HH:mm:ss

  • yyyy'年'M'月'd'日'

  • yyyy'年'M'月'd'日'day

  • yyyy-MM-dd

  • yyyyMMdd

  • yyyy'年'M'月'd'日' ahh'时'mm'分'ss'秒'

  • yyyy-MM-dd hh:mm:ss

Français (French)

  • HH:mm:ss

  • d Mon yy

  • d Month yyyy

  • day d Month yyyy

  • dd-MM-yy

  • dd-MM-yyyy

  • dd/MM/yy

  • dd/MM/yyyy

  • yyyy-MM-dd

  • yyyyMMdd

  • d Mon yy HH:mm:ss

  • yyyy-MM-dd hh:mm:ss

  • dd/MM/yyyy hh:mm:ss

  • dd/MM/yy hh:mm:ss

Deutsch (German)

  • HH:mm:ss

  • dd.MM.yy

  • dd.MM.yyyy

  • d. Month yyyy

  • day, dd. Month yyyy

  • day, d. Month yyyy

  • dd-MM-yy

  • dd-MM-yyyy

  • dd/MM/yy

  • dd/MM/yyyy

  • yyyy-MM-dd

  • yyyyMMdd

  • dd.MM.yy HH:mm

  • dd.MM.yyyy HH:mm:ss

  • yyyy-MM-dd hh:mm:ss

  • dd/MM/yyyy hh:mm:ss

  • dd/MM/yy hh:mm:ss

Italiano (Italian)

  • HH:mm:ss

  • dd/Mon/yy

  • dd Month yyyy

  • day d Month yyyy

  • dd-MM-yy

  • dd-MM-yyyy

  • dd/MM/yy

  • dd/MM/yyyy

  • yyyy-MM-dd

  • yyyyMMdd

  • dd/Mon/yy HH:mm:ss

  • yyyy-MM-dd hh:mm:ss

  • dd/MM/yyyy hh:mm:ss

  • dd/MM/yy hh:mm:ss

日本語 (Japanese)

  • 'hh'時'mm'分'ss'秒'

  • HH:mm:ss

  • yyyy'年'M'月'd'日'day

  • yyyy'年'M'月'd'日

  • M'月'd'日'

  • yyyy-MM-dd

  • yyyyMMdd

  • yyyy-MM-dd hh:mm:ss

Português (Portuguese)

  • HH:mm:ss

  • d' de 'Month' de 'yyyy

  • Day, d' de 'Month' de 'yyyy

  • dd-MM-yy

  • dd-MM-yyyy

  • dd/MM/yy

  • dd/MM/yyyy

  • yyyy-MM-dd

  • yyyyMMdd

  • yyyyMMdd H.mm

  • yyyy-MM-dd hh:mm:ss

  • dd/MM.yyyy hh:mm:ss

  • dd/MM.yy hh:mm:ss

Español (Spanish)

  • HH:mm:ss

  • d' de 'Month' de 'yyyy

  • day d' de 'Month' de 'yyyy

  • dd-MM-yy

  • dd-MM-yyyy

  • dd/MM/yy

  • dd/MM/yyyy

  • yyyy-MM-dd

  • yyyyMMdd

  • yyyyMMdd H.mm

  • yyyy-MM-dd hh:mm:ss

  • dd/MM/yyyy hh:mm:ss

  • dd/MM/yy hh:mm:ss

In this section: