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/04/2018 07:37?
Thanks for your help.

Q

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

3 Replies

  • 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