Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Problem with date format

saibal_78
8 - Asteroid

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

2 REPLIES 2
cmcclellan
14 - Magnetar

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

 

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

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. 

 

WorkflowWorkflowResultsResults

Labels
Top Solution Authors