userdatevalue() Function

Function

userdatevalue( date_text )

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

See also: datetext()

Parameters

Keyword Type Description

date_text

Text

The date to be converted into a serial number.

Returns

Date

Usage considerations

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

Open in Github Built: Tue, May 23, 2023 (06:12:33 PM)

On This Page

FEEDBACK