Filter

There is currently a new feature in development: In addition to the currently known dates it will be possible to choose relative periods. A click in the date field opens the datepicker. Clicking on the pencil next to the date field allows to type freely. Using one of the keys below allows the date field to convert the text into the right parameters.

ATTENTION: Each of these values describes a single date and not a range of dates!

…………………….

Day after tomorrow:

• the day after tomorrow
• day after tomorrow

Tomorrow:

• tomorrow

Today:

• today

Yesterday:

• yesterday
• last day

Day before yesterday:

• the day before yesterday
• day before yesterday

First day of this week:

• monday
• this monday
• beginning of the week
• beginning of week

Last day of this week:

• friday
• this friday
• end of the week
• end of week

First day of last week:

• last monday
• beginning of last week
• last week

Last day of last week:

• last friday
• end of last week

First day of next week:

• next monday
• begin next week
• beginning of the next week
• beginning of next week
• next week

Last day of next week:

• next friday
• end of the next week
• end of next week

First day of this month:

• this month
• month
• beginning of month
• beginning of this month
• begin of month
• begin of this month

First day of next month:

• next month
• beginning of next month
• beginning of the next month
• begin of next month
• begin of the next month

First day of the month after next month:

• month after next
• month after next month
• beginning of month after next
• beginning of month after next month

First day of the last month:

• last month
• beginning of last month
• beginning of the last month
• begin of last month
• begin of the last month

First day of the month before the last month:

• month before last
• month before last month
• beginning of month before last
• beginning of month before last month

Last day of this month:

• monatsende
• end of this month
• end of month

Last day of next month:

• end of next month
• end of the next month

Last day of the month after next month:

• end of month after next
• end of month after next month

Last day of the last month:

• end of last month
• end of the last month

Last day of the month before last month:

• end of month before last
• end of month before last month

First day of this quarter:

• this quarter
• begin of quarter
• begin of this quarter
• quarter

First day of next quarter:

• next quarter
• begin of next quarter
• begin of the next quarter

First day of last quarter:

• last quarter
• begin of last quarter
• begin of the last quarter

Last day of this quarter:

• end of this quarter
• end of quarter

Last day of next quarter:

• end of next quarter
• end of the next quarter

Last day of last quarter:

• end of last quarter
• end of the last quarter

First day of the first quarter:

• quarter 1
• first quarter

First day of the second quarter:

• quarter 2
• second quarter

First day of the third quarter:

• quarter 3
• third quarter

First day of the fourth quarter:

• quarter 4
• fourth quarter

Last day of the first quarter:

• end of quarter 1
• end of first quarter

Last day of the second quarter:

• end of quarter 2
• end of second quarter

Last day of the third quarter:

• end of quarter 3
• end of third quarter

Last day of the fourth quarter:

• end of quarter 4
• end of fourth quarter

First day of this year:

• year
• this year
• begin of this year

Last day of this year:

• end of year
• sylvester

First day of next year:

• next year

First day of last year:

• last year

Last day of next year:

• end of next year

Last day of last year:

• end of last year

EXTRA: any parameter from above + or - any number followed by

• day
• days
• d

• w
• week
• weeks

• m
• month
• months

• year
• years
• y

allows to increase / decrease the date accordingly.

I.e.: „today-1d“ is the same as „yesterday“.