Question

Date Time Transformation in Number

0

Good morning everyone, how do I transform a date and time into a number in Mendix?

asked 2021-10-08

Josimar José Nepomuceno

3 answers

Tim v Steenbergen · Answer 1 · 2021-10-08

Count seconds between Epoch an now to get the Unix-timestamp:

toString(secondsBetween([%CurrentDateTime%], dateTime(1970,1,1)))

Dates before 1970: prefix with ‘-’

Shekhar Tyagi · Answer 2 · 2021-10-08

What`s your purpose? One possible way is to take the difference from a constant date like 01.01.001

Martin Koelewijn · Answer 3 · 2021-10-08

The CommunityCommons module has a DateTimeToLong java action you could use.