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
Solved! Go to Solution.
I needed to convert it to a date first, so this works :)
DateTimeFormat( DateTimeParse([Completed Date],"%d-%b-%y"), "%b" )