Date Function

[micky01]

Hi All,

I have a formula tool  which calculates 'DateTimeToday() '  but I want to display  the output as DD-MMM-YY.

Any thoughts.

Thanks

[JosephSerpis]

Hi @micky01 you would need to wrap that function in a datetimeformat function and ensure the data type is a string to get that output. I mocked up an example let me know what you think?

[JulioMO]

Hi @micky01 

Try to add the "DateTime" Tool in order to display the date in the required form.

[Qiu · Accepted solution]

@micky01 

Like this

[messi007 · Accepted solution]

@micky01,

Please see below: 

DateTimeFormat(DateTimeToday(),"%d-%b-%y")

Regards,

[NitishSrivastava · Accepted solution]

Hello @micky01,

You can try this. It will be helpful for you.

Thanks

Nitish

[micky01]

Thank you Joseph.

Just wondering how to get this format DD-MMM-YY.

[JosephSerpis · Accepted solution]

Hi @micky01 Alteryx only recognises YYYY-MM-DD e.g. 2021-02-17 as a valid date data format any other format such as DD-MMM-YYYY 17-Feb-2021 has to be a string data format. The rationale is the datatime functions within Alteryx only work with YYYY-MM-DD formats.  The function datetimeformat(DateTimeToday(),"%d-%b-%y") will give you a format of DD-MMM-YY lowercasing the y changes the format of the year. The specifiers for datatime functions can be found here.

[Emil_Kos · Accepted solution]

Hi @micky01,

Like @JosephSerpis stated. If you are interested in keeping the format that you have mentioned you need to change the data type to string.

If you will use the formula tool and change the data type to string you will get something like this:

I have used the below formula in order to get this result:

DateTimeFormat(DateTimeToday(),'%d-%b-%y')

[micky01]

Thank you Joseph for detail explanation.