âShow Table of Contents
The DateTime tool transforms date/time data to and from a variety of formats, including both expression-friendly and human readable formats.
Alteryx cannot process dates prior to January 1, 1400.
Select the format to convert:
Select Custom to specify your own format. Alteryx will then show an example based on the format you specify.
You can use the specifiers and separators as described below (for example, dd, MM, yyyy), or the specifiers and separators supported by the DateTimeParse and DateTimeFormat functions (for example, %d, %m, %Y).
You can use an asterisk * as a wildcard character to replace any character in the date format field.
On output, separators in the date/time format are used exactly. On input:
Â©2017 Alteryx, Inc., all rights reserved. AllocateÂ®, AlteryxÂ®, GuzzlerÂ®, and SolocastÂ® are registered trade