Date format issue in excel

Help Activities
, ,
1

I have three columns in excel of date i.e last update,first_update and due by and the format of the date is m/d/yyyy hh:mm:ss tt.how to write it?
TIA

2

@Cuberoot

What do you mean by how to write?

are you trying to enter data or reaad?

inside for each row in datatable Cdate(row("Date").ToString) will parse it

cheers

3

@Cuberoot where you want to write it. Do you want to change its format?

4

I am just copying the data from one file to another file when it copies the data date is coming like this-2022-05-22 04:57:50 AM.that is the issue

5

@Cuberoot

that depends on the excel cell format you can change the format for cells manually or using format cells activity

cheers