Issue with converting a 10 digit datex whole number date field into DD/MM/YYYY format

[Anonymous]

I have a dataset taken from one of our systems which stores dates in the form of 10 digit serial number as shown below and I am really struggling to convert it into a date format of DD/MM/YYYY.

I was wondering if anyone has ever dealt or seen dates in this format and know of a way around this issue as I cannot use the data type function to change it as I get an error.

[v-cherch-msft · Accepted solution]

Hi @Anonymous

You may try to add a custom column and then you may change the format to DD/MM/YYYY in data type format.  For example:

#datetime(1970, 1, 1, 0, 0, 0) + #duration(0, 0, 0, [Column1]/1000)

Regards,

Cherie

[Anonymous]

Thank You so much @v-cherch-msft that did the trick! 🙂