Forum Discussion
PaulPeterson1
5 years agoQrew Assistant Captain
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
------------------------------
PaulPeterson1
5 years agoQrew Assistant Captain
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
------------------------------
ToSeconds([Date Created] - ToTimestamp(ToDate("1/1/1970"), ToTimeOfDay("00:00:00")))
------------------------------
Paul Peterson
------------------------------