Date and Time functions
Function List:
- Date
- DateAdd
- DateDiff
- DateNow
- DateParse
- DateTime
- DayOfMonth
- DayOfWeek
- DayOfYear
- Hour
- Millisecond
- Minute
- Month
- Quarter
- Second
- Time
- TimeParse
- Today
- Weeknum
- Year
Date(year
, month
, day
)
Returns a date composed of the specified year
, month
and day
.
Date(2002, 3, 15)
DateAdd(dt
, ts
)
Returns the date dt
with the time span ts
appended to it.
DateAdd(${StartDate}, ${Duration})
DateDiff(dt1
, dt2
)
Returns the difference (time span) between two dates dt1
and dt2
.
DateDiff(${FirstDate}, ${SecondDate})
DateNow()
Returns the current date.
DateAdd(DateNow(), ${Duration})
DateParse(s
)
Constructs and returns a date based on string pattern s
.
DateParse("20120227T132700") // 2012-02-27 13:27:00.000
DateTime(year
, month
, day
, hours
, minutes
, seconds
, milliseconds
)
Returns a date composed of the specified parameters.
DateTime(2002, 3, 15, 23, 59, 45, 999)
DayOfMonth(dt
)
Returns the day of the month for the date dt
.
DayOfMonth(Date(2021, 6, 14)) // 14
DayOfWeek(dt
)
Returns the day of the week for the date dt
. The days of the week are numbered from 1 to 7.
DayOfWeek(Date(2020, 12, 31)) // 4
DayOfYear(dt
)
Returns the day of the year for the date dt
.
DayOfYear(Date(2021, 2, 25)) // 56 (31 + 25)
Hour(dt
)
Returns the hour of the date dt
.
Hour(DateTime(2002, 3, 15, 23, 59, 45, 999)) // 23
Millisecond(dt
)
Returns the millisecond of the date dt
.
Millisecond(DateTime(2002, 3, 15, 23, 59, 45, 999)) // 999
Minute(dt
)
Returns the minute of the date dt
.
Minute(DateTime(2002, 3, 15, 23, 59, 45, 999)) // 59
Month(dt
)
Returns the month of the date dt
.
Month(DateTime(2002, 3, 15, 23, 59, 45, 999)) // 3
Quarter(dt
)
Returns the quarter of the date dt
.
Quarter(Date(2002, 3, 15)) // 1
Second(dt
)
Returns the second of the date dt
.
Second(DateTime(2002, 3, 15, 23, 59, 45, 999)) // 45
Time(hours
, minutes
, seconds
, milliseconds
)
Returns a time composed of the specified parameters.
The time is actually a DateTime with a special insignificant date 0001-01-01
.
Time(23, 59, 45, 999) // 0001-01-01 23:59:45.999
TimeParse(s
)
Constructs and returns a time based on string pattern s
.
The time is actually a DateTime with a special insignificant date 0001-01-01
.
TimeParse("13:27") // 0001-01-01 13:27:00.000
Today()
Returns today's date.
Today() // On January 1, 2021, would return the value 01-01-2021 00:00:00.000
Weeknum(dt
)
Returns the week number of the date dt
.
Weeknum(Date(2021, 2, 3)) // 5
Year(dt
)
Returns the year of the date dt
.
Year(Date(2021, 2, 3)) // 2021