none
Convert to Date - 1476975600921 RRS feed

  • Question

  • Hi,

    From the REST API, I am getting the date value as 1476975600921. 

    How can I get he actual date from it using M language?

    Thanks in advance

    Regards

    Milind



    Best Regards

    Thursday, October 27, 2016 10:10 AM

Answers

  • This is just a blind shot...  but it looks like time in miliseconds... so, maybe...

    DateAndTime = DateTime.From(25569 + YourValueFromRestAPI/86400000)
    Regards


    • Edited by Bill Szysz Thursday, October 27, 2016 12:11 PM
    • Marked as answer by milind bangar Thursday, October 27, 2016 12:40 PM
    Thursday, October 27, 2016 12:10 PM

All replies

  • This is just a blind shot...  but it looks like time in miliseconds... so, maybe...

    DateAndTime = DateTime.From(25569 + YourValueFromRestAPI/86400000)
    Regards


    • Edited by Bill Szysz Thursday, October 27, 2016 12:11 PM
    • Marked as answer by milind bangar Thursday, October 27, 2016 12:40 PM
    Thursday, October 27, 2016 12:10 PM
  • Thanks Bill...

    Best Regards

    Thursday, October 27, 2016 12:40 PM