How to preserve data format in a process

Help Activities
, , , ,
1

In input file date is in dd-MM-yyyy format and when add data to queue it shows mm-dd-yyyy
I can’t process with MM-dd-yyyy
How can preserve date format as dd-MM-yyyy through out process at the end using write range. I’m writing input datatable to excel it’s date is shows MM/dd/yyyy.

2

@Anil_Potekar

When you read the data from excel…if you use visible or display value then you will get same as what you see…else it takes the value which is in backend which you can see on excel top when you open the excel and select the excel cell

And when you write to excel…you have to make sure you format the cell to required format or add a appstrophe before the date

“'22-12-2022”

Hope this helps

Cheers

1 Like