Excel: Date On File

[neromerob]

Hello.

I´m woking in a workflow where I used a Formula tool to produce an Output with the day, month and year in  the name, but that´s not the result that I Required.

Thank you

[Nick-C · Accepted solution]

Hi @neromerob , you'll just need to change the DateTimeFormat to be the below:

DateTimeFormat(DateTimeNow(), "%B %Y")

This is a great link to save to your favourites for all the different  datetime functions:

https://help.alteryx.com/20221/designer/datetime-functions 

If this helps, please mark this as solved so other users can find it! 

[IraWatt]

Hey @neromerob,

you just need to replace the date time format function with this:

DateTimeFormat(DateTimeNow(),"%b %Y")

All the format options are given here in the docs: DateTime Functions | Alteryx Help

Any questions or issues please ask :)
HTH!
Ira