Problem with date format

[saibal_78]

Hi All,

I have a file (CSV) where I have list of dates in 1st column as 2-Jan-2017, I want only month "Jan" in the next column. I used below formula

DateTimeFormat([Completed Date], "%b") but its giving me "NULL value, any help on this would be highly appreciated. Attached is the file where I have input data.

Thanks

[cmcclellan · Accepted solution]

I needed to convert it to a date first, so this works :)

DateTimeFormat(
	DateTimeParse([Completed Date],"%d-%b-%y"),
	"%b"
)

[ponraj · Accepted solution]

Attaching a sample workflow for your case.  First, convert your date into alteryx format using Datetime tool then use formula DateTimeFormat([DateTime_Out],"%b") to parse out month alone.  Hope it helps. 

WorkflowResults