Default Date Placeholders
today |
current date (UMC from Server + Offset Administration - Timezone) |
heute x |
today (UMC from Server + Offset Administration - Timezone) +/- specified days |
heute_bis |
today UMC from Server + Offset Administration - Timezone) 12:00 pm |
year |
current year UMC from Server + Offset Administration - Timezone) |
month |
current month UMC from Server + Offset Administration - Timezone) |
now |
current time (UMC from Server + Offset Administration - Timezone) |
DATETIME FUNCTIONS
eom(date) |
end of month %eom(<today,yyyy/mm/dd>) |
bom(date) |
begin of month |
eoy(date) |
end of year |
boy(date) |
begin of year |
month(date) |
number of month |
day(date) |
number of day |
dayofweek(date) |
day of week (1=Monday) |
relativedate(date,numberof days) |
Date after/before adding/subtracting numberofdays |
workday(date,numberofdays) |
Date after adding numberofdays workdays |
weekyear(date) |
week in format yyyycc. Value is taken from factory calendar |
weekstring(date) |
format week in yyyy/cc setvar=ls_week=%weekstring(<today,yyyy/mm/dd>) return for date 2011/02/24: "2011/01" |
week(date) |
week in format cc. This value is taken from the factory calendar, e.g. it is depending on the settings |
CalendarWeek(date) |
week in format cc. This value is calculated according to ISO 8601 |
CalendarYearWeek(date) |
week in format yyyycc. This is the calculated value.
|
firstdayofweek(date) |
return the first day of this week |
lastdayofweek(date) |
return the last day of this week setvar=ls_week=%weekstring(<today,yyyy/mm/dd>) return for date 2011/02/24: "2011/02/27" |
week2date(Jahrwoche yyyyww) |
converts week to date |
monthname(date) |
name of month |
dayname(date) |
name of week-day |
dbdatetime(date,time) |
converts date, time to the database-format which can be specified in the WHERE-clause (depending on the Database-Server) |
add_month(date,int month) |
return date + count of month setvar=ls_date=2016/05/01 setvar=ls_date=%add_month(<ls_date>,3) result: 2016/08/01 |