Community

Date and Time

Last updated
Save as PDF

Collaborate with us

Edit this page on GitHub

Name	Description
AddDays(DateTime, Integer)	Adds 'n' days to 'dt' and returns a valid Date Time.
AddHours(DateTime, Integer)	Adds 'n' hours to 'dt' and returns a valid Date Time.
AddMinutes(DateTime, Integer)	Adds 'n' minutes to 'dt' and returns a valid Date Time.
AddMonths(DateTime, Integer)	Adds 'n' months to 'dt' and returns a valid Date Time.
AddSeconds(DateTime, Integer)	Adds 'n' seconds to 'dt' and returns a valid Date Time.
AddYears(DateTime, Integer)	Adds 'n' years to 'dt' and returns a valid Date Time.
BuildDateTime(Date, Time)	Returns a Date Time made up of the Date 'd' and Time 't'.
CurrDate()	In client-side calls, it returns the device date. In server-side calls, it returns the platform server date. In query calls, it returns the platform server date.
CurrDateTime()	In client-side calls, it returns the device date and time. In server-side calls, it returns the platform server date and time. In query calls, it returns the platform server date and time. Date times in the device are converted in the server to the server time zone. Conversely, date times in the server are converted in the device to the device time zone.
CurrTime()	In client-side calls, it returns the device time. In server-side calls, it returns the platform server time. In query calls, it returns the platform server time.
Day(DateTime)	Returns the day of 'dt'.
DayOfWeek(DateTime)	Returns the week day of 'dt', ranging from 0 (Sunday) to 6 (Saturday).
DiffDays(DateTime, DateTime)	Returns the difference in days between 'dt1' and 'dt2'; i.e. how many days have passed between these two dates: - Returns a positive number if 'dt1' is smaller than 'dt2'; - Returns a negative number if 'dt1' is bigger than 'dt2'; - Returns 0 if the two dates are equal. The Time component you provide in the parameters is ignored. The DiffDays function receives two Date Time parameters, and then replaces the Time component with 00:00:00. It calculates the elapsed time in milliseconds from the first date at 00:00:00 to the second date at 00:00:00, and then converts the difference in milliseconds into days. Daylight Saving Time (DST) is ignored. The time zone considered for evaluating this function is always the time zone of the Platform Server, regardless of the regional settings of the end user. The maximum supported value is (2^31)-1 days. This corresponds to approximately 5879489.8 years. If DiffDays(dt1, dt2) is bigger than (2^31)-1, you will get an unexpected value.
DiffHours(DateTime, DateTime)	Returns the difference in hours between 'dt1' and 'dt2'; i.e. how many hours have passed between these two dates: - Returns a positive number if 'dt1' is smaller than 'dt2'; - Returns a negative number if 'dt1' is bigger than 'dt2'. - Returns 0 if the two dates are equal. Daylight Saving Time (DST) is ignored. The time zone considered for evaluating this function is always the time zone of the Platform Server, regardless of the regional settings of the end user. The maximum supported value is (2^31)-1 hours. This corresponds to approximately 244978.74 years. If DiffHours(dt1, dt2) is bigger than (2^31)-1, you will get an unexpected value.
DiffMinutes(DateTime, DateTime)	Returns the difference in minutes between 'dt1' and 'dt2'; i.e. how many minutes have passed between these two dates: - Returns a positive number if 'dt1' is smaller than 'dt2'; - Returns a negative number if 'dt1' is bigger than 'dt2'. - Returns 0 if the two dates are equal. Daylight Saving Time (DST) is ignored. The time zone considered for evaluating this function is always the time zone of the Platform Server, regardless of the regional settings of the end user. The maximum supported value is (2^31)-1 minutes. This corresponds to approximately 4085.78 years. If DiffMinutes(dt1, dt2) is bigger than (2^31)-1, you will get an unexpected value.
DiffSeconds(DateTime, DateTime)	Returns the difference in seconds between 'dt1' and 'dt2'; i.e. how many seconds have passed between these two dates: - Returns a positive number if 'dt1' is smaller than 'dt2'; - Returns a negative number if 'dt1' is bigger than 'dt2'. - Returns 0 if the two dates are equal. Daylight Saving Time (DST) is ignored. The time zone considered for evaluating this function is always the time zone of the Platform Server, regardless of the regional settings of the end user. The maximum supported value is (2^31)-1 seconds. This corresponds to approximately 68.10 years. If DiffSeconds(dt1, dt2) is bigger than (2^31)-1, you will get an unexpected value.
Hour(DateTime)	Returns the hour of 'dt'.
Minute(DateTime)	Returns the minute of 'dt'.
Month(DateTime)	Returns the month of 'dt'.
NewDate(Integer, Integer, Integer)	Returns a Date made up of year 'y', month 'm' and day 'd'.
NewDateTime(Integer, Integer, Integer, Integer, Integer, Integer)	Returns a Date Time made up of year 'y', month 'mo', day 'd', hour 'h', minute 'mi' and second 's'.
NewTime(Integer, Integer, Integer)	Returns a Time made up of hour 'h', minute 'm' and second 's'.
Second(DateTime)	Returns the seconds of 'dt'.
Year(DateTime)	Returns the year of 'dt'.

AddDays

Adds 'n' days to 'dt' and returns a valid Date Time.

Available in:

Server-side logic: Yes
Client-side logic: Yes
Database: Can be used with attributes in aggregates.
Local Storage: Can be used with attributes in aggregates.

Parameters

dt: Type: DateTime. Mandatory.
The Date Time to add days to.
n: Type: Integer. Mandatory.
The number of days to add.

Output

Type: DateTime

Examples

AddDays(#2015-09-14#, 15) = #2015-09-29 00:00:00#
AddDays(#2015-12-31#, 1) = #2016-01-01 00:00:00#
AddDays(#2015-02-28#, 1) = #2015-03-01 00:00:00#
AddDays(#2016-02-28#, 1) = #2016-02-29 00:00:00#

AddHours

Adds 'n' hours to 'dt' and returns a valid Date Time.

Available in:

Server-side logic: Yes
Client-side logic: Yes
Database: Can be used with attributes in aggregates.
Local Storage: Can be used with attributes in aggregates.

Parameters

dt: Type: DateTime. Mandatory.
The Date Time to add hours to.
n: Type: Integer. Mandatory.
The number of hours do add.

Output

Type: DateTime

Examples

AddHours(#1982-05-21 22:20:30#, 1) = #1982-05-21 23:20:30#
AddHours(#2001-10-12 23:20:00#, 5) = #2001-10-13 04:20:00#

AddMinutes

Adds 'n' minutes to 'dt' and returns a valid Date Time.

Available in:

Server-side logic: Yes
Client-side logic: Yes
Database: Can be used with attributes in aggregates.
Local Storage: Can be used with attributes in aggregates.

Parameters

dt: Type: DateTime. Mandatory.
The Date Time to add minutes to.
n: Type: Integer. Mandatory.
The number of minutes to add.

Output

Type: DateTime

Examples

AddMinutes(#1982-05-21 22:20:30#, 1) = #1982-05-21 22:21:30#
AddMinutes(#2001-10-12 23:55:00#, 5) = #2001-10-13 00:00:00#

AddMonths

Adds 'n' months to 'dt' and returns a valid Date Time.

Available in:

Server-side logic: Yes
Client-side logic: Yes
Database: Can be used with attributes in aggregates.
Local Storage: Can be used with attributes in aggregates.

Parameters

dt: Type: DateTime. Mandatory.
The Date Time to add months to.
n: Type: Integer. Mandatory.
The number of months to add.

Output

Type: DateTime

Examples

AddMonths(#2001-09-14#, 2) = #2001-11-14 00:00:00#
AddMonths(#2001-12-14#, 2) = #2002-02-14 00:00:00#
AddMonths(#2003-01-31#, 1) = #2003-02-28#
AddMonths(#2004-01-31#, 1) = #2004-02-29#

AddSeconds

Adds 'n' seconds to 'dt' and returns a valid Date Time.

Available in:

Server-side logic: Yes
Client-side logic: Yes
Database: Can be used with attributes in aggregates.
Local Storage: Can be used with attributes in aggregates.

Parameters

dt: Type: DateTime. Mandatory.
The Date Time to add seconds to.
n: Type: Integer. Mandatory.
The number of seconds to add.

Output

Type: DateTime

Examples

AddSeconds(#2015-05-21 22:20:30#, 60) = #2015-05-21 22:21:30#
AddSeconds(#2003-10-21 23:59:50#, 11) = #2003-10-22 00:00:01#

AddYears

Adds 'n' years to 'dt' and returns a valid Date Time.

Available in:

Server-side logic: Yes
Client-side logic: Yes
Database: Can be used with attributes in aggregates.
Local Storage: Can be used with attributes in aggregates.

Parameters

dt: Type: DateTime. Mandatory.
The Date Time to add years to.
n: Type: Integer. Mandatory.
The number of years to add.

Output

Type: DateTime

Examples

AddYears(#2001-09-14#, 3) = #2004-09-14 00:00:00#
AddYears(#2004-02-29#, 1) = #2005-02-28 00:00:00#
AddYears(#2004-02-29#, 4) = #2008-02-29 00:00:00#

BuildDateTime

Returns a Date Time made up of the Date 'd' and Time 't'.

Available in:

Server-side logic: Yes
Client-side logic: Yes
Database: Can be used with attributes in aggregates.
Local Storage: Can be used with attributes in aggregates.

Parameters

d: Type: Date. Mandatory.
The Date to build the Date Time from.
t: Type: Time. Mandatory.

Output

Type: DateTime

Examples

BuildDateTime(#2015-07-14#, #12:30:34#) = #2015-07-14 12:30:34#

CurrDate

In client-side calls, it returns the device date.
In server-side calls, it returns the platform server date.
In query calls, it returns the platform server date.

Available in:

Server-side logic: Yes
Client-side logic: Yes
Database: Can be used with attributes in aggregates.
Local Storage: Function is evaluated before the aggregate is executed.

Output

Type: Date

CurrDateTime

In client-side calls, it returns the device date and time.
In server-side calls, it returns the platform server date and time.
In query calls, it returns the platform server date and time.

Date times in the device are converted in the server to the server time zone.
Conversely, date times in the server are converted in the device to the device time zone.

Available in:

Server-side logic: Yes
Client-side logic: Yes
Database: Can be used with attributes in aggregates.
Local Storage: Function is evaluated before the aggregate is executed.

Output

Type: DateTime

CurrTime

In client-side calls, it returns the device time.
In server-side calls, it returns the platform server time.
In query calls, it returns the platform server time.

Available in:

Server-side logic: Yes
Client-side logic: Yes
Database: Can be used with attributes in aggregates.
Local Storage: Function is evaluated before the aggregate is executed.

Output

Type: Time

Day

Returns the day of 'dt'.

Available in:

Server-side logic: Yes
Client-side logic: Yes
Database: Can be used with attributes in aggregates.
Local Storage: Can be used with attributes in aggregates.

Parameters

dt: Type: DateTime. Mandatory.
The Date Time to calculate the day from.

Output

Type: Integer

Examples

Day(#2015-07-14#) = 14

DayOfWeek

Returns the week day of 'dt', ranging from 0 (Sunday) to 6 (Saturday).

Available in:

Server-side logic: Yes
Client-side logic: Yes
Database: Can be used with attributes in aggregates.
Local Storage: Can be used with attributes in aggregates.

Parameters

dt: Type: DateTime. Mandatory.
The Date Time to calculate the day of the week from.

Output

Type: Integer

Examples

DayOfWeek(#2001-09-14#) = 5

DiffDays

Returns the difference in days between 'dt1' and 'dt2'; i.e. how many days have passed between these two dates:

Returns a positive number if 'dt1' is smaller than 'dt2';
Returns a negative number if 'dt1' is bigger than 'dt2';
Returns 0 if the two dates are equal.

The Time component you provide in the parameters is ignored. The DiffDays function receives two Date Time parameters, and then replaces the Time component with 00:00:00. It calculates the elapsed time in milliseconds from the first date at 00:00:00 to the second date at 00:00:00, and then converts the difference in milliseconds into days.

Daylight Saving Time (DST) is ignored. The time zone considered for evaluating this function is always the time zone of the Platform Server, regardless of the regional settings of the end user.

The maximum supported value is (2^31)-1 days. This corresponds to approximately 5879489.8 years. If DiffDays(dt1, dt2) is bigger than (2^31)-1, you will get an unexpected value.

Available in:

Server-side logic: Yes
Client-side logic: Yes
Database: Can be used with attributes in aggregates.
Local Storage: Can be used with attributes in aggregates.

Parameters

dt1: Type: DateTime. Mandatory.
The first Date Time.
dt2: Type: DateTime. Mandatory.
The second Date Time.

Output

Type: Integer

Examples

DiffDays(#1982-05-19#, #1982-05-21#) = 2
DiffDays(#1982-05-21#, #1982-05-19#) = -2
DiffDays(#2005-05-11 00:00:00#, #2005-05-11 23:59:59#) = 0
DiffDays(#2004-09-01#, #2004-10-01#) = 31
DiffDays(#2004-09-01 23:00:00#, #2004-09-02 00:10:00#) = 1
DiffDays(#2004-09-01 23:00:00#, #2004-09-02 23:30:00#) = 1
DiffDays(#2014-03-30 00:00:00#, #2014-03-31 00:00:00#) = 1, assuming the GMT+1 time zone (2014 Daylight Saving Time starts in Europe on March 30 of 2014). If your server is in a different time zone, you will get different results.
DiffDays(#2014-10-25 00:00:00#, #2014-10-26 00:00:00#) = 1, assuming the GMT+1 time zone (2014 Daylight Saving Time ends in Europe on October 26 of 2014). If your server is in a different time zone, you will get different results.

DiffHours

Returns the difference in hours between 'dt1' and 'dt2'; i.e. how many hours have passed between these two dates:

Returns a positive number if 'dt1' is smaller than 'dt2';
Returns a negative number if 'dt1' is bigger than 'dt2'.
Returns 0 if the two dates are equal.

Daylight Saving Time (DST) is ignored. The time zone considered for evaluating this function is always the time zone of the Platform Server, regardless of the regional settings of the end user.

The maximum supported value is (2^31)-1 hours. This corresponds to approximately 244978.74 years. If DiffHours(dt1, dt2) is bigger than (2^31)-1, you will get an unexpected value.

Available in:

Server-side logic: Yes
Client-side logic: Yes
Database: Can be used with attributes in aggregates.
Local Storage: Can be used with attributes in aggregates.

Parameters

dt1: Type: DateTime. Mandatory.
The first Date Time.
dt2: Type: DateTime. Mandatory.
The second Date Time.

Output

Type: Integer

Examples

DiffHours(#1982-05-21 22:20:30#, #1982-05-22 02:00:00#) = 4
DiffHours(#1982-05-22 02:00:00#, #1982-05-21 22:20:30#) = -4
DiffHours(#2005-05-11 10:59:00#, #2005-05-11 10:00:00#) = 0
DiffHours(#2005-05-11 10:00:00#, #2005-05-12 10:00:00#) = 24
DiffHours(#2005-05-11 10:59:00#, #2005-05-12 15:00:00#) = 29
DiffHours(#2006-03-25 15:00:00#, #2006-03-26 15:00:00#) = 24, assuming the GMT+1 time zone (2006 Daylight Saving Time starts in Europe on March 26 of 2006). If your server is in a different time zone, you will get different results.
DiffHours(#2006-10-28 15:00:00#, #2006-10-29 15:00:00#) = 24, assuming the GMT+1 time zone (2006 Daylight Saving Time ends in Europe on October 29 of 2006). If your server is in a different time zone, you will get different results.

DiffMinutes

Returns the difference in minutes between 'dt1' and 'dt2'; i.e. how many minutes have passed between these two dates:

Returns a positive number if 'dt1' is smaller than 'dt2';
Returns a negative number if 'dt1' is bigger than 'dt2'.
Returns 0 if the two dates are equal.

Daylight Saving Time (DST) is ignored. The time zone considered for evaluating this function is always the time zone of the Platform Server, regardless of the regional settings of the end user.

The maximum supported value is (2^31)-1 minutes. This corresponds to approximately 4085.78 years. If DiffMinutes(dt1, dt2) is bigger than (2^31)-1, you will get an unexpected value.

Available in:

Server-side logic: Yes
Client-side logic: Yes
Database: Can be used with attributes in aggregates.
Local Storage: Can be used with attributes in aggregates.

Parameters

dt1: Type: DateTime. Mandatory.
The first Date Time.
dt2: Type: DateTime. Mandatory.
The second Date Time.

Output

Type: Integer

Examples

DiffMinutes(#1982-05-21 22:20:30#, #1982-05-21 22:26:00#) = 6
DiffMinutes(#1982-05-21 22:26:00#, #1982-05-21 22:20:30#) = -6
DiffMinutes(#1982-05-21 22:26:00#, #1982-05-21 22:26:59#) = 0
DiffMinutes(#1982-05-21 22:26:30#, #1982-05-21 22:27:20#) = 1
DiffMinutes(#1982-05-21 22:26:30#, #1982-05-21 22:27:40#) = 1
DiffMinutes(#2006-05-21 15:00:00#, #2006-05-22 15:00:00#) = 1440
DiffMinutes(#2006-03-25 15:00:00#, #2006-03-26 15:00:00#) = 1440, assuming the GMT+1 time zone (2006 Daylight Saving Time starts in Europe on March 26 of 2006). If your server is in a different time zone, you will get different results.
DiffMinutes(#2006-10-28 15:00:00#, #2006-10-29 15:00:00#) = 1440, assuming the GMT+1 time zone (2006 Daylight Saving Time ends in Europe on October 29 of 2006). If your server is in a different time zone, you will get different results.

DiffSeconds

Returns the difference in seconds between 'dt1' and 'dt2'; i.e. how many seconds have passed between these two dates:

Returns a positive number if 'dt1' is smaller than 'dt2';
Returns a negative number if 'dt1' is bigger than 'dt2'.
Returns 0 if the two dates are equal.

Daylight Saving Time (DST) is ignored. The time zone considered for evaluating this function is always the time zone of the Platform Server, regardless of the regional settings of the end user.

The maximum supported value is (2^31)-1 seconds. This corresponds to approximately 68.10 years. If DiffSeconds(dt1, dt2) is bigger than (2^31)-1, you will get an unexpected value.

Available in:

Server-side logic: Yes
Client-side logic: Yes
Database: Can be used with attributes in aggregates.
Local Storage: Can be used with attributes in aggregates.

Parameters

dt1: Type: DateTime. Mandatory.
The first Date Time.
dt2: Type: DateTime. Mandatory.
The second Date Time.

Output

Type: Integer

Examples

DiffSeconds(#1982-05-21 22:20:30#, #1982-05-21 22:21:05#) = 35
DiffSeconds(#1982-05-21 22:21:05#, #1982-05-21 22:20:30#) = -35
DiffSeconds(#2006-05-21 15:00:00#, #2006-05-22 15:00:00#) = 86400
DiffSeconds(#2006-03-25 15:00:00#, #2006-03-26 15:00:00# ) = 86400, assuming the GMT+1 time zone (2006 Daylight Saving Time starts in Europe on March 26 of 2006). If your server is in a different time zone, you will get different results.
DiffSeconds(#2006-10-28 15:00:00#, #2006-10-29 15:00:00#) = 86400, assuming the GMT+1 time zone (2006 Daylight Saving Time ends in Europe on October 29 of 2006). If your server is in a different time zone, you will get different results.

Hour

Returns the hour of 'dt'.

Available in:

Server-side logic: Yes
Client-side logic: Yes
Database: Can be used with attributes in aggregates.
Local Storage: Can be used with attributes in aggregates.

Parameters

dt: Type: DateTime. Mandatory.
The Date Time to extract the hours from.

Output

Type: Integer

Examples

Hour(#1982-05-21 22:20:30#) = 22

Minute

Returns the minute of 'dt'.

Available in:

Server-side logic: Yes
Client-side logic: Yes
Database: Can be used with attributes in aggregates.
Local Storage: Can be used with attributes in aggregates.

Parameters

dt: Type: DateTime. Mandatory.
The Date Time to extract the minutes from.

Output

Type: Integer

Examples

Minute(#1982-05-21 22:20:30#) = 20

Month

Returns the month of 'dt'.

Available in:

Server-side logic: Yes
Client-side logic: Yes
Database: Can be used with attributes in aggregates.
Local Storage: Can be used with attributes in aggregates.

Parameters

dt: Type: DateTime. Mandatory.
The Date Time to extract the month from.

Output

Type: Integer

Examples

Month(#2001-09-14#) = 9

NewDate

Returns a Date made up of year 'y', month 'm' and day 'd'.

Available in:

Server-side logic: Yes
Client-side logic: Yes
Database: Can be used with attributes in aggregates.
Local Storage: Can be used with attributes in aggregates.

Parameters

y: Type: Integer. Mandatory.
The year of the Date.
m: Type: Integer. Mandatory.
The month of the Date.
d: Type: Integer. Mandatory.
The day of the Date.

Output

Type: Date

Examples

NewDate(2002, 6, 3) = #2002-06-03#

NewDateTime

Returns a Date Time made up of year 'y', month 'mo', day 'd', hour 'h', minute 'mi' and second 's'.

Available in:

Server-side logic: Yes
Client-side logic: Yes
Database: Can be used with attributes in aggregates.
Local Storage: Can be used with attributes in aggregates.

Parameters

y: Type: Integer. Mandatory.
The year of the Date Time.
mo: Type: Integer. Mandatory.
The month of the Date Time.
d: Type: Integer. Mandatory.
The day of the Date Time.
h: Type: Integer. Mandatory.
The hours of the Date Time.
mi: Type: Integer. Mandatory.
The minutes of the Date Time.
s: Type: Integer. Mandatory.
The seconds of the Date Time.

Output

Type: DateTime

Examples

NewDateTime(2002, 6, 3, 22, 0, 59) = #2002-06-03 22:00:59#

NewTime

Returns a Time made up of hour 'h', minute 'm' and second 's'.

Available in:

Server-side logic: Yes
Client-side logic: Yes
Database: Can be used with attributes in aggregates.
Local Storage: Can be used with attributes in aggregates.

Parameters

h: Type: Integer. Mandatory.
The hours of the Time.
m: Type: Integer. Mandatory.
The minutes of the Time.
s: Type: Integer. Mandatory.
The seconds of the Time.

Output

Type: Time

Examples

NewTime(22, 0, 59) = #22:00:59#

Second

Returns the seconds of 'dt'.

Available in:

Server-side logic: Yes
Client-side logic: Yes
Database: Can be used with attributes in aggregates.
Local Storage: Can be used with attributes in aggregates.

Parameters

dt: Type: DateTime. Mandatory.
The Date Time to extract the seconds from.

Output

Type: Integer

Examples

Second(#2015-05-21 22:20:30#) = 30

Year

Returns the year of 'dt'.

Available in:

Server-side logic: Yes
Client-side logic: Yes
Database: Can be used with attributes in aggregates.
Local Storage: Can be used with attributes in aggregates.

Parameters

dt: Type: DateTime. Mandatory.
The Date Time to extract the year from.

Output

Type: Integer

Examples

Year(#2015-07-14#) = 2015

Training

Documentation