Datetime function

[Jackmcc17]

Hi guys, could someone elaborate on the functions on the datetime tool a little bit? Can the tool convert a date time value to a formatted string? Convert a date to a custom formatted string with specifier? 

[atcodedog05]

Hi @Jackmcc17 

You can right-click on any tool in the palette and click on open example. This will open an Alteryx documented example with explanation.

Here is the snapshot of the workflow:

Tool mastery on it : https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-DateTime/ta-p/38302 

Hope this helps : )

[terry10]

Yes, the DateTime tool can convert a date or datetime value to a string. In the tool configuration, you can pick the format of the new string from a list or specify a custom format using the specifiers listed on this page.

[danilang]

Hi @Jackmcc17 

As well as the examples, check out the DateTime Tool Mastery Article.  While the DateTime tool is useful, the real power comes from using the DateTime functions in a formula tool.  As well as having all the capabilities of the DateTime tool, the DateTime functions allow you add/subtract time intervals, find durations, find the first day of any given month and many other useful operations

Dan