userdatetime() Function

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.

Using this function in a process model with autoscale enabled may result in degraded site or application performance. It should be used with caution and tested thoroughly before deploying it for real-world use. When the application is in production, use the Autoscaled Process Activity tab to monitor how the process performs at scale.

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

Feature compatibility

The table below lists this function's compatibility with various features in Appian.

Feature	Compatibility	Note
Portals	Partially compatible	Can be used with Appian Portals if it is connected using an integration and web API.
Offline Mobile	Partially compatible	Can be used with offline mobile if it is loaded at the top of the form.
Sync-Time Custom Record Fields	Incompatible
Real-Time Custom Record Fields	Incompatible	Custom record fields that evaluate in real time must be configured using one or more Custom Field functions.
Process Reports	Incompatible	Cannot be used to configure a process report.
Process Events	Incompatible	Cannot be used to configure a process event node, such as a start event or timer event.
Process Autoscaling	Partially compatible	Using this function in a process model with autoscale enabled may result in degraded site or application performance.

Feedback