Convert double to a datetime

[langsem]

Hello i am trying to perform something. I am getting a double value thats the format “20200308”
i want to format this into a datetime format and formatted this way 2020-08-03

Anyone know how ? thanks in advance

[hasib08 (Motiwala Hasib)]

Convert.ToDateTime(your_variable).ToString(“your_format”)

Thanks

[ppr (Peter Preuss)]

@langsem
DateTime.ParseExact(YourStringVar, “yyyyddMM”, CultureInfo.InvariantCulture).toString(“yyyy-MM-dd”)
assumed 8 ist Month

ensure following:

[langsem]

I want the output to be a string with the dateformat. Shall i just assign it to a string ?

[langsem]

It worked :D!" THanks m8

[ppr (Peter Preuss)]

a datetime can be formated on string base onto another format representation. the internal representation of a date time will not be changed ( is not to modify). Yes. It will be string (Have a look on the screenshot column datatype)