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.
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
