Forum Discussion

qs's avatar
qs
Helper I
8 years ago
Solved

Convert Date format

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/0...
Need Help
  • MFelix's avatar
    MFelix
    8 years ago

    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

MFelix's avatar
MFelix
Super User
8 years ago

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's avatar
qs
Helper I
8 years ago

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's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    Hi qs,

     

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

     

    Best Regards,
    Dale