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
------------------------------
- PaulPeterson15 years agoQrew Assistant CaptainRemove 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
------------------------------