Date / Time to Epoch Milliseconds
Is there a way to convert Date / Time to Epoch Milliseconds ? I want to use it in my webhook message body like this : { "epoch_date_created" : [Date Created] } But [Date Created] returns some...
Forum Discussion
Try this:
ToMSeconds([Date Created] - ToTimestamp(ToDate("1/1/1970"), ToTimeOfDay("00:00:00")))
------------------------------
Paul Peterson
------------------------------
ToMSeconds([Date Created] - ToTimestamp(ToDate("1/1/1970"), ToTimeOfDay("00:00:00")))
------------------------------
Paul Peterson
------------------------------
- Remove the "M" from the formula and you will get the results you're looking for:
ToSeconds([Date Created] - ToTimestamp(ToDate("1/1/1970"), ToTimeOfDay("00:00:00")))
------------------------------
Paul Peterson
------------------------------