Convert Date format

[qs]

Hello all,
Let's go straight to the point.
I have a table with this type of date format: 1524728255.  which stands for 2018/04/26 07:37.
I would like to know how can I convert 1524728255 into 26/04/2018 07:37?
Thanks for your help.

Q

[MFelix · Accepted solution]

Hi @qs,

I'm assuming that you are refering to a date standard that counts the number of seconds since 1970 however looking at you post we don't have much information so it's difficult to get an answer (check this link by @Greg_Deckler)

However make a new column with the following code shoud work as you need:

Formated =
DATE ( 1970; 1; 1 )
    + ( Table1[Date] / 60
    / 60
    / 24 )

Regards,

MFelix

[qs]

@MFelix

Thanks for your solution. I will give a go with your suggestion and will keep you in the loop.

Best

Q

[v-jiascu-msft]

Hi @qs,

Did the solution work? Could you please mark the proper answer as solution?

Best Regards,
Dale