month to year 04/2020 to end of the month

[Raj_2]

Hi there,

I need a help on below date format conversion

01/2019- 31/01/2019

02/2020- 29/02/2020

05/2018-31/05/2018

Thanks in advance.

RJ

[JosephSerpis · Accepted solution]

Hi @Raj_2 I mocked up a workflow that produces your output. Let me know what you think?

[DavidP]

You can do it with a combination of DateTime function tools

datetimeformat(todate(datetimeadd(datetimeadd(DateTimeParse([old date],'%m/%Y'),1,'month'),-1,'day')),'%d/%m/%Y')

[christine_assaad]

hi @Raj_2 

Please see below. Hope it helps.

[Raj_2]

wondeful