I want to Convert 13MAR23 into 13-03-2023

[NishantGaur]

I want to Convert 13MAR23 into 13-03-2023 via Blue prism calculation stage how can i do this.

[MichealCharron]

@NishantGaur

The following formula should work for you:

FormatDate(ToDate([Source Date]), "dd-MM-yyyy")

The month abbreviation will be recognized by the ToDate() function and not have a problem converting the string into a Date type. The FormatDate() function can then be used to format it the way that you want.

[harish.mogulluri]

Hi Nishant Gaur,

You can try  below format date function

FormatDate("13MAR23", "dd-MM-yyyy")

[MichealCharron]

@NishantGaur

@Harish Mogulluri has the better answer. I forgot that the FormatDate() function will do the casting for you.