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?
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 : )
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.
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