Data table with date column

[Karsten_Bertelsen (KB)]

Hi,

I have extracted a data table with a “date” column.

I am adding this value to my own data table by using for each row (in string format)

Here is my question: how can i change the format to a date, so that it both is accepted to the data table, but also stored as an variable?

BR Karsten

[Anthony_Humphries]

You will need to create a new column with the Date datatype and update the rows with the converted version of your string dates.

Unfortunately, you cannot change the datatype of a column in one step, since it would erase the data.

[Karsten_Bertelsen (KB)]

Thanks for the reply!
Which one of these variables would do the job?

My date is writtes as “07/05/2020”

[Anthony_Humphries]

System.Datetime would be best.

[Karsten_Bertelsen (KB)]

Is this the same type as Excel uses for dates?

[Karsten_Bertelsen (KB)]

The assign function is: new datetime(2020,05,07)

[supermanPunch (Arpan)]

@Karsten_Bertelsen I guess the variables that you have used in the DateTime() are not of integer type, Can you change it to integer and check if it works.