Interprets the given date in the user preferred calendar and converts it into an equivalent serial number.
userdatevalue( date_text )
date_text: (Text) The date to be converted into a serial number.
Date
To display the date, always wrap the output with datetext()
.
You can copy and paste these examples into the Expression Rule Designer to see how this works.
datetext(userdatevalue("8/18/1427"),"yyyy/MM/dd") returns
1427/8/18`