Date Time Now Tool
One Tool Example
Date Time Now has a One Tool Example. Visit 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.
Configure the Tool
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.
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.
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
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
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
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
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
'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
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
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