Chech the list here: https://docs.mendix.com/refguide7/expressions, especially https://docs.mendix.com/refguide7/parse-and-format-date-function-calls.
Create a datetime variable in a microflow and hit ctrl+space to see options.
“now”: [%CurrentDateTime%]
likewise for differences: create a decimal variable and do daysBetween([%CurrentDateTime%], $YourObject/DateTimeAttributeToCheck).
There is a yearsBetween Java action in the CommunityCommons module in the app store.
Thanks for your quick response. I have viewed the documents and I am missing a few of functions. I am wandering is the documentation not complete or is Mendix not complete?
I am missing functions like:
Datetime now → datetime() requires at least 1 argument. I want the datetime at the executed moment.
Days difference between 2 datetimes.
Years difference between 2 datetimes.
What functions can I use do get this information?