datetime() Function

Function

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

Converts the given Date and Time into a serial number that holds the Date and Time data type.

Parameters

Keyword	Type	Description
year	Integer	The year of the you would like to convert into a serial number.
month	Integer	Only numbers are accepted, not month names. Do not include leading zeroes for a month with one digit.
day	Integer	The day of the Date and Time.
hour	Integer	The hour of the Date and Time.
minute	Integer	The minute of the Date and Time.
second	Integer	The seconds of the Date and Time.

Returns

Date and Time

Usage considerations

The value is converted to GMT when stored.

Examples

datetime(2011,2,28,12,0,0) returns 2/28/2011 7:00 AM EST

Appending a Time to a Date:

datetime(year(pv!yourDate), month(pv!yourdate), day(pv!yourDate), 23, 59, 00) returns 6/8/1984 7:59 PM EDT by adding the time 11:59 pm to a given date where pv!yourDate is 6/8/1984 and applying the timezone conversion.

See Also

userdatetime(): Use this function to return a Datetime value in the local time zone.

Feature compatibility

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

Feature	Compatibility	Note
Portals	Compatible
Offline Mobile	Compatible
Sync-Time Custom Record Fields	Compatible	Can be used to create a custom record field that only evaluates at sync time.
Real-Time Custom Record Fields	Incompatible
Process Reports	Compatible
Process Events	Compatible

Feedback