Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Datetime function

Jackmcc17
6 - Meteoroid

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? 

3 REPLIES 3
atcodedog05
22 - Nova
22 - Nova

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:

atcodedog05_0-1631875351602.png

 

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

 

Hope this helps : )

terry10
11 - Bolide

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.

 

terry10_3-1631935130915.png

 

 

 

danilang
19 - Altair
19 - Altair

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 

Labels