In ELMA, you can use relative dates to filter objects.
To use relative dates, open the advanced search form (fig. 1), check the Relative Dates box and select a relative period for the time interval start and end. The relative date is always the current date on ELMA server.
If the period end field is empty, the time period will be unlimited.
Values of relative time periods
Below is the list of possible time periods with examples.
As an example, we will be using 12.08.2016 as the current date
Today - current day: 12.08.2016.
Yesterday - previous day: 11.08.2016.
This Week – calendar week, from Monday to Sunday, which includes the current date: from 8.08.2016 to 14.08.2016.
Previous Week - previous week, from Monday to Sunday: from 01.08.2016 to 07.08.2016.
Previous 7 days - previous seven days, relative to the current date: 05.08.2016.
This Month – calendar month, which includes the current date: from 01.08.2016 to 31.08.2016.
Previous Month - previous month, relative to the current date: from 01.07.2016 to 31.07.2016.
Current Year – calendar year, which includes the current date: from 01.01.2016 to 31.12.2016.
Previous Year - previous year, relative to the current date: from 01.01.2015 to 31.12.2015.
String expression of a relative date
A string expression of a relative date has the following conventions:
"-" – previous period (year, month, etc.).
"+" – next period (year, month, etc.).
<Number> - number of time attributes (days, weeks, months). "0" means the current time attribute.
<Letter> – time attribute:
h – hour;
d – day;
w – week;
m – month;
y – year.
For example, string expression "-5d" means five days ago from the current date.
Rules for writing a relative date expression
You can type a relative date expression in the period start and end fields as: <Period marker (+/-)> <number of time attributes> <time attribute>. If the value is "0", you don't have to use the period marker (+/-).
Each expression can contain several time attributes.
For example, to find tasks created between two days on the last week, use this expression (fig. 3):
<-1w+1d> to <-1w+2d> .
Fig. 3. Advanced search form. Complex expressions of relative dates
Relative date accuracy
If the exact time is not specified, then the date is calculated from 0:00am in the beginning of the period to 11:59pm in the end of the period.
