Date Conversion

[Birdman1971]

Morning - simple one i am sure 

I have a data with the date shown as 300424 ( April 2024 ) and I would like 30/04/2024 - what's the most efficient way of transforming please?  

[aatalai · Accepted solution]

@Birdman1971 check out the workflow attached, it is using the formula tool with the following expression 

datetimeformat(datetimeparse(ToString([Date]),"%d%m%y"),"%d/%m/%Y")

NB this is if your field is in number format, if it is already in string then you will not need the t string element.

Let me know how you get on

[Deano478]

Hey @Birdman1971 Have a look at the attached it should work but bear in mend to format dates like this they will be strings

[Birdman1971]

Thanks all , really appreciate your help

[Birdman1971]

Worked perfectly - thank you so much