Skip to main content
Question

Using webhooks, I need a date field in milliseconds from the epoch...but I get MM-DD-YYYY. Is there an easy way to get milliseconds from the epoch UTC into a formula?

  • September 29, 2016
  • 0 replies
  • 32 views

There are lots of people doing the reverse from the API calls but I need to try and get it into the "Message body" of a Webhook.  I can pick my date using [Invoice Date] but it spits out MM-DD-YYYY.  I also tried to create another field that is formulated from that date...but I don't see any of the options I'm looking for other than parsing the date...then brute forcing the seconds.

This topic has been closed for replies.

  • Registered
  • September 29, 2016
This formula will return milliseconds as a number:

ToMSeconds ([Date])

Forum|alt.badge.img+6
Dan, Is there a way to achieve this with a timestamp (Date and Time) using a QB formula?
Basically I need a Unix timestamp from a QB date and time