Date Functions in Alteryx

[pnaveen]

Hi,

I am trying to convert some of my date functions in Alteryx and need some help on converting these functions in alteryx. Thanks and appreciated.

Below are the date functions i need to convert them in Alteryx.

1) DATENAME('month',[DATE])

2)YEAR([DATE])

~ Navee

[KGT]

What do your formulas mean? Are they Excel functions? 

The second one, I'm guessing pulls the year out of a date, which you can do many ways, and I'm sure there's a function for it, but I always just use Left([Date],4).

Is the first one pulling the name of a month out of the date? If so, DateTimeParse([Date],'%B')

You will find that Alteryx is actually really really good with dates. Take a look at the below, and the specifiers on that page.

https://help.alteryx.com/current/en/designer/functions/datetime-functions.html

[Qiu · Accepted solution]

@pnaveen 

As mentioned by @KGT , Alteryx has a lot of functions that can dateTime conversion.

In your case, I think its SQL Statement, we can use the DateTimeFormat function particularly.

[pnaveen]

Thanks Que , this helps