Convert Number Month to String Month

[NBPSE]

My excel input file is a number as shown below. How can I use Alteryx to output this as 'July'

 

 

[Qiu]

@NBPSE 

This should help .

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Convert-Date/td-p/1296139

[Raj]

@NBPSE 
find the workflow attached Mark done if solved.

datetimeformat(DateTimeParse([Date], "%m/%d/%Y"),"%B")

[NBPSE]

I tried this formula and it is giving me a Null output. Does something need to be changed?

 

[ChrisTX · Accepted solution]

After your Excel data is imported to Alteryx, what is the data type for field [Document Date] ?

I'm guessing it may be a Date.

Try only the DateTimeFormat function:

   DateTimeFormat([Document Date],"%B")

See the list of DateTime functions here:  https://help.alteryx.com/current/en/designer/functions/datetime-functions.html##

Chris

[NBPSE]

Yes it is Date, thank you, this worked!

[NBPSE]

I am also formatting a date, but it is outputting as 07/01/2024. How can I have the output read 7/1/2024?

[ChrisTX]

please explain "it is outputting as 07/01/2024"

what is "it"?  What is the data type you are starting with?  Date?

Use the function DateTimeFormat.  review the link I sent for DateTime functions, and check out the section for Specifiers

Chris

[NBPSE]

This is the output I am getting from using the DateTimeFormat formula. I see your specifiers and have tried a few combinations of %e to replace the leading zero with a space, and intend to cleanse the data after to remove any leading zeros. Currently my combinations of using the %e are not updating the date output as I would expect. What formula would remove the leading zeros in formatting this date (for month and day)?

 

[ChrisTX · Accepted solution]

Sometimes Alteryx makes it hard.  There isn't a specifier to convert a 0 to a space, in a month value.

Combine a few functions:

ReplaceChar(TrimLeft(DateTimeFormat([f1],"%m/%e/%Y"),"0"), " ", "")

 

Chris