View source for Selection conditions for objects by dates

{{#seo:
|title=Selection conditions for objects by dates
|titlemode=append
|keywords=planfix, planner, filter, reports, setup, date, date conditions
|description=Selection criteria for objects by dates
}}
During the [[Object selection parameters|selection of objects]] in filters, Planner lists, or Planfix reports, you may need to specify the required time period for which to make the selection. Planfix has a whole list of such conditions:

https://s.pfx.so/pf/RH/4DI9rr.jpg

The principle of how date conditions work is intuitive in most cases, but some can cause difficulties. Let's break them down with examples for easier understanding.

Any date condition operates with a time period. For example, let's take 7 days.

== '''Last...''' ==

This is a period of time equal to 7 days that has passed up to and including today:

https://s.pfx.so/pf/VE/PwMc5E.jpg
 
For instance, today is the 10th of the month. With this condition, objects will be selected from the 4th to the 10th of the month inclusive.

== '''Next...''' ==

This is a period of time equal to 7 days that will be after today:

https://s.pfx.so/pf/rt/ndag51.jpg
 
For example, today is the 1st of the month. With this condition, objects will be selected from the 2nd to the 8th of the month.

== '''In...''' ==

This is the day that will come after the specified number of days:

https://s.pfx.so/pf/DT/JBlZ9P.jpg

For instance, we must select objects appearing in 7 days (i.e., on the 8th day) after today. With this condition, if today is the 1st of the month, the objects will be selected for the 9th of the month.

== '''Conditions''' ==

Sometimes there are difficulties in understanding mathematical conditions applied to a date or time period. Below is a picture that will help you understand how to read such conditions:

https://s.pfx.so/pf/Iu/65NMxj.jpg
 
*'''<''' — less than — select objects whose status change date occurred earlier than the specified day or the beginning of the specified time period.

*'''=''' — equal to — select objects whose status change date is equal to the specified day or time period.

*'''>''' — greater than — select objects whose status change date will occur later than the specified day or the end of the specified time period.

For example, how to understand the condition for the selection parameter '''Status change date''':

https://s.pfx.so/pf/iz/ZEQIRV.jpg

The whole sentence looks like this: Planfix, please select objects for me, the '''status change date''' of which is '''less than''' the beginning of the period '''last 7 days'''.


== Go To ==
*[[Object selection parameters]]
*[[Types of planner lists]]
*[[Task filters]]