Forum Discussion

qs's avatar
qs
Icon for Helper I rankHelper 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
Icon for Super User rankSuper 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
    Icon for Helper I rankHelper 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
      Icon for Microsoft Employee rankMicrosoft Employee
      8 years ago

      Hi qs,

       

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

       

      Best Regards,
      Dale