Date - (Built-in Functions)
Date
CvDate - Convert year/month/day and optional hours/minutes/seconds numbers to a date/time number.
The returned value can be compared with values read from database columns with type SQL_DATE, SQL_TIME or SQL_TIMESTAMP or can be formatted as a string using FormatDate.
Expression Syntax: CvDate(year, month, day, hour, minutes, seconds)
year: The year in the range 100 to 9999.
month: The month, in the range 0 to 12.
day: The day, in the range 0 to 31.
hour: The hour, in the range 0 to 23 (optional).
minutes: The minute, in the range 0 to 59 (optional).
seconds: The second, in the range 0 to 59 (optional).
Example:
CvDate(2001, 6, 29, 11, 27, 0)
returns 29/06/2001 11:27:00
Date - The date/time number of the current date/time, or of the given date/time as a property or as a literal date string.
Expression Syntax: Date(date)
date: A property or a literal string representing a date.
Example:
Date()
returns the current date and time.
Date(someDateAndTime@)
returns a date time value for a date property.
Date("2001-06-29T11:27:00")
returns 29/06/2001 11:27:00.
Day - Gets the day of the month (in the range 1 to 31) represented by a date/time value.
Expression Syntax: Day(date)
date
A date time value of the calendar month required.
Example:
Day(Date())
returns the current day of the month.
Day(someDateAndTime@)
returns the Month day of the date.
Day(Date("2001-06-29T11:27:00"))
returns 29.
DayOfWeek - Gets the day of the week in the range 1 to 7; 1=Sunday, 2=Monday, etc. represented by a date/time value.
Expression Syntax: DayOfWeek(date)
date
A date time value of the week day required
Example:
DayOfWeek(Date())
returns the current day of the week.
DayOfWeek(someDateAndTime@)
returns the week day of the date.
DayOfWeek(Date("2001-06-29T11:27:00"))
returns 6.
DayOfYear - Gets the day of the year in the range 1 to 366; 1=1st January, 32=1st February, etc.) from a date/time value.
Expression Syntax: DayOfYear(date)
date
A date time value of the annual day required
Example:
DayOfYear(Date())
returns the current day of the year.
DayOfYear(someDateAndTime@)
returns the annual day of the date.
DayOfYear(Date("2001-06-29T11:27:00"))
returns 180.
Hour - Gets the hour (in the range 0 to 23) represented by a date/time value.
Expression Syntax: Hour(property)
property
The name of the date/time property.
Example:
Hour(startdate@)
returns the hour in the date/time property entered in the property field, in this example startdate@.
Minute - Gets the minute value (in the range 0 to 59) represented by a date/time value.
Expression Syntax: Minute(property)
property
The name of the date/time property.
Example:
Minute(startdate@)
returns the minute in the date/time property entered in the property field, in this example startdate@.
Month - Gets the month (1=January, 2=February, etc.) represented by a date/time value.
Expression Syntax: Month(property)
property
The name of the date/time property.
Example:
Month(startdate@)
returns the month in the date/time property entered in the property field, in this example startdate@.
Now - Returns a date for the current date and time.
Expression Syntax: Now()
Example:
Now()
Returns today's date and time in the format day/month/year hour/minute/seconds
ParseDate - Converts a string into a date.
Expression Syntax: ParseDate(str$)
Example:
ParseDate(startdate$)
returns the month in the date/time property entered in the property field, in this example startdate$.
Second - Gets the second value (in the range 0 to 59) represented by a date/time value.
Expression Syntax: Second(property)
property
The name of the date/time property.
Example:
Second(startdate@)
returns the second in the date/time property entered in the property field, in this example startdate@.
Timespan - Calculates a timespan value.Timespan returns a decimal value of days from a given number of days, hours, minutes and seconds.
Expression Syntax: Timespan(days, hours, minutes, seconds)
days: The number of days.
hours: The number of hours.
minutes: The number of minutes.
seconds: The number of seconds.
Note: If days, hours, minutes or seconds values are not required enter 0 in the appropriate position in the parameter line.
Examples:
Timespan(13, 19, 30, 0)
will return 13.8125
Timespan(0, 18, 0, 0)
will return 0.75
Year - Gets the year (in the range 100 to 9999) represented by a date/time value.
Expression Syntax: Year(property)
Example:
Year(startdate@)
returns the year in the date/time property entered in the property field, in this example startdate@.