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

Date to String conversion - Alternative methods

EN6924
10 - Fireball

We can convert from date to string as mentioned below -

 

EN6924_0-1647526126277.png

 

I want to know how this can be done using formula tool, also vice versa (String to date).

If we have multiple columns to convert, Is it necessary to configure like below? Or it's possible using a single tool -

EN6924_1-1647526430664.png

 

Please guide.

 

6 REPLIES 6
binuacs
20 - Arcturus

@EN6924 

binuacs_0-1647526796846.png

 

Luke_C
17 - Castor

Hi @EN6924 

 

If you have multiple columns you could use a multi-field formula tool to facilitate this. The formulas are:

 

DateTimeParse() To convert string to date

DateTimeFormat() To convert date to string

 

I personally have this page bookmarked, it's a one stop shop for all the date syntax: DateTime Functions | Alteryx Help

Luke_C
17 - Castor

@EN6924 Here's an example of the multi-field I mentioned

 

Luke_C_0-1647527078201.png

 

 

EN6924
10 - Fireball

Hi @binuacs 

 

Thanks for the help, I do have some more queries.

 

In my data, fields having 'Date' and 'Date-Time' datatype.

 

EN6924_0-1647527420832.png

What will be the single formula to convert DateTime to String?

 

EN6924_2-1647528550523.png

 

Kindly assist.

 

 

EN6924
10 - Fireball

@Luke_CJust checked using Multi-field formula and it's working. Thank you 😊

binuacs
20 - Arcturus

@EN6924 to convert DateTimne to string you need use the DateTimeFormat() function

 

https://help.alteryx.com/20214/designer/datetime-functions

 

Labels