topic Re: I want to Convert 13MAR23 into 13-03-2023 in Product Forum

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

NishantGaur — Wed, 20 Dec 2023 17:27:18 GMT

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

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

MichealCharron — Wed, 20 Dec 2023 19:29:18 GMT

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.

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

harish.mogulluri — Wed, 20 Dec 2023 19:38:14 GMT

Hi Nishant Gaur,

You can try below format date function

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

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

MichealCharron — Wed, 20 Dec 2023 19:42:56 GMT

@NishantGaur

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