Need date output format as dd-mm-yyyy

[sriku]

Hi,

I need to convert to dd-mm-yyyy format. I tried using datetime  and used formula datetimeparse but not getting the desired out. Can any one help:

Date
01.04.2020
01.04.2019
01.04.2018
01.06.2020
01.05.2020
01.04.2020
01.03.2020
01.02.2020
01.01.2020
01.12.2019
01.11.2019
01.10.2019
01.09.2019
01.08.2019
01.07.2019
01.06.2019
01.05.2019
01.04.2019

[JosephSerpis · Accepted solution]

Hi I mocked up a workflow let me know what you think?

[BradWerner · Accepted solution]

Hi @sriku,

I see I am late to the party! @JosephSerpis has a great solution.

I am just posting mine as an alternative way of doing it since I was mid-response. No worries! Both get you where you need to go (see attached workflow).

Have a great day!

Brad

[chc9]

Hi

I have a similar question.

I have output in standard Alteryx datetime as 2018-07-15.

How can I convert that to British datetime format 15-07-2018?

Then I want to do a formula to subtract one day.  Pls can you help me change this to 14-07-2018.

Thanks

Harry

[grazitti_sapna]

Hi @chc9 , try this formula.

DatetimeFormat(DateTimeAdd([Date],-1,"days"),"%d-%m-%Y")

Thanks.

[chc9]

This worked!  Thank you!