Selection conditions for objects by dates: Difference between revisions

From Planfix
Jump to: navigation, search
(Created page with "{{#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 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.j...")
 
 
(One intermediate revision by one other user not shown)
Line 59: Line 59:
*[[Object selection parameters]]
*[[Object selection parameters]]
*[[Types of planner lists]]
*[[Types of planner lists]]
*[[Reports]]
*[[Task filters]]
*[[Task filters]]

Latest revision as of 14:11, 22 December 2023

During the 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:

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:

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:

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:

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:

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:

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