Folder creating with wrong format

Hi i have Data in excel column as in date Format (02-01-2023)

while i creating a folder with name of the each value in that column am getting folder creation like below ,can anyone help me why it was creating like that.
its not creating a folder of actual date (02-01-2023).instead it creating like below
Screenshot 2023-05-04 114001

HI,

Kindly enable the preserve format property in your read range activity, looks like it is retrieving with /, and we can’t create path with those characters

another option could be to make a replace method, with - and / for _

Regardsw

can you check the value of currentRow(2) in locals panel what exactly you are getting
if you are getting in 02/01/2023 format or 02-03-2023 format
Regards

Am getting in this format 02/01/2023

Hi @sekhar_talasila ,

Try the following:

"C:\Users\sekha\Desktop\"+Cdate(CurrentRow(2).tostring).tostring("dd-MM-yyyy")

Regards,

1 Like

may be that could be the reason

can you try after tostring add .replace(“/”,“-”)

Regards

Thanks Vishal it worked. May i know what CDate(0) refers in your solution.

@sekhar_talasila , we use cdate to convert string to date format and thereby again convert the date to our desired format i.e. dd-MM-yyyy

Regards,

Thank you so much…now i got it

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.