userdatetime() Function

Scripting Functions

This function cannot be used with Custom Record Field Expressions. It can only be used with Offline Mobile if it is loaded at the top of the form.
For a full list of functions and their feature compatibility, explore the Appian Functions table.

Function

userdatetime( year, month, day, hour, minute, second )

Interprets the given date and time in the user preferred calendar and converts it into a serial number.

See also: datetext()

Parameters

Keyword	Type	Description
`year`	Number	The year of the datetime you would like to convert into a serial number.
`month`	Number	The number of the month of the datetime.
`day`	Number	The day of the datetime.
`hour`	Number	The hour of the datetime.
`minute`	Number	The minute of the datetime.
`second`	Number	The seconds of the datetime.

Returns

DateTime

Usage considerations

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

For the month parameter, do not include leading zeroes for a month with one digit.

Examples

You can copy and paste these examples into the Expression Rule Designer to see how this works.

datetext(userdatetime(1427,8,18,1,2,0)) returns 08/18/1427 01:02 AM

Open in Github Built: Fri, Sep 22, 2023 (07:57:45 PM)

userdatetime() Function