Free cookie consent management tool by TermsFeed userdatetime() Function
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.

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
Process Reports Incompatible

You cannot use this function to configure a process report.

Process Events Incompatible

You cannot use this function to configure a process event node, such as a start event or timer event.

Open in Github Built: Thu, Mar 28, 2024 (10:34:21 PM)

userdatetime() Function

FEEDBACK