userdatevalue() Function

Interprets the given date in the user preferred calendar and converts it into an equivalent serial number.

Syntax

userdatevalue( date_text )

Notes

date_text: (Text) The date to be converted into a serial number.

Returns

Date

Notes

To display the date, always wrap the output with datetext().

Examples

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") returns1427/8/18`

See Also

datetext()

FEEDBACK