Date Format Error

[Jeyaraj_M]

Hi,

I am trying to convert the date format but it shows an error as invalid date format

Customer	Valid from
123456	1-Nov-18
2258976	1-Oct-18

My expected output is

Customer	Valid from
123456	11.2018
2258976	10.2018

[purnimat]

Hi @Jeyaraj_M ,

Using the Date Time parse tool and the Formula tool, you can achieve the desired output.

Hope this helps !

[DavidP · Accepted solution]

You can also do it all in one with a formula

[Jeyaraj_M]

Can you please share me that Workflow?

i tried it but it is not converting to the expected output please

[purnimat]

Here you go @Jeyaraj_M