Converts the given Date and Time into a serial number that holds the Date and Time data type.
datetime( year, month, day, [hour], [minute], [second] )
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.
Date and Time
The value is converted to GMT when stored.
You can experiment with this function in the test box below.
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
is 6/8/1984 and applying the timezone conversion.
userdatetime(): Use this function to return a Datetime value in the local time zone.