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“.