Casting for text to date

[RPG]

Hello all,
I am new in Blue prism. I want to convert a text type data dd/mm/yyyy to date format.
Please help.

 

[drubiano]

Use a calculation stage, use convert to date

 

[sivagelli]

Use Calc stage and use expression FormatDate(ToDate("02-05-2019"), "dd/MM/yyyy"), this turns the text passed to Date type and formats to dd/mm/yyyy.

ToDate() works well with no error when you have text with either / or . or - between year month and date.

BP assumes the date format from the system settings.

 

[spark113]

Still getting an error, when using same expression

 

[Sachin_Kharmale]

Hi @spark113 ,

What is the error message ?

try give date in format which is present on your system date like MM/DD/YYYY then use same data to convert as per your requirement.
FormatDate(ToDate("Your system date format eg MM/DD/YYYY"), "dd/MM/yyyy")

and then try to format date may be it will work for you .


I hope it will help you ....!