Folder creating with wrong format

[sekhar_talasila]

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

[fernando_zuluaga]

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

[LAKSHMI_NARAYANA_PEMMASAN (LAKSHMI NARAYANA)]

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

[sekhar_talasila]

Am getting in this format 02/01/2023

[vishal.kp (vishal)]

Hi @sekhar_talasila ,

Try the following:

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

Regards,

[LAKSHMI_NARAYANA_PEMMASAN (LAKSHMI NARAYANA)]

may be that could be the reason

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

Regards

[sekhar_talasila]

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

[vishal.kp (vishal)]

@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,

[sekhar_talasila]

Thank you so much…now i got it