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: Date01.04.202001.04.201901.04.201801.06.202001.05.202001.04.202001.03.202001.02.202001.01.202001.12.201901.11.201901.10.201901.09.201901.08.201901.07.201901.06.201901.05.201901.04.2019

Need date output format as dd-mm-yyyy

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

Parse

Preparation

Accepted answers

JosephSerpis

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

Dates_Format_30072020.yxmd

BradWerner

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

Brad Date Format.yxmd

All comments

JosephSerpis

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

Dates_Format_30072020.yxmd

BradWerner

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

Brad Date Format.yxmd

chc9

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703