How to change format date

[MaTT_P]

Hi, in the below formula I would like to change  format date marked in yellow in below screenshot from 2021-04-05 to 04.05.2021 (MM.DD.YYYY) or 04.05.21 (MM.DD.YY)

 

[AngelosPachis]

Hi @MaTT_P ,

You can use a formula tool and the Datetimeformat function to convert today's date to the desired format

The syntax you should use is the following 

DateTimeFormat([Today],"%m.%d.%Y")

You can find more info about the datetime functions in the following link

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

One thing to note is that your [Converted] field, will now be of a String data type, so you won't be able to make any date calcs using that field.

A second way that would give you the same result is the Datetime tool, which is configured slightly differently

Hope that helps,

Angelos

[Qiu]

@MaTT_P 
We can use DateTimeFormat function

[Qiu]

@AngelosPachis 
very nice and detailed explained.👍

[AngelosPachis]

Thanks @Qiu 😀

[MaTT_P]

Hi, thank you for explenation, I would like to use this to replace below date from below screen marked on yellow. As i understand from above i cant use this,  Are you able to help me solve this issue?

 

[danilang]

Hi @MaTT_P 

Replace the yellow [Date] from your formula with @AngelosPachis' formula so it becomes

...+ DateTimeFormat([Today],"%m.%d.%Y") + ".xlsx"+"|||...

Dan