Date to String conversion - Alternative methods

[EN6924]

We can convert from date to string as mentioned below -

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 -

Please guide.

[binuacs · Accepted solution]

@EN6924 

[Luke_C]

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 · Accepted solution]

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

[EN6924]

Hi @binuacs 

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

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

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

Kindly assist.

[EN6924]

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

[binuacs]

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

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