This thread is resolved. Here is a description of the problem and solution.
Problem:
How to add a query filter to a view which shows posts with a custom date field value from the past year.
Solution:
When adding the query filter, values such as PAST_YEAR and PAST_MONTH will refer to the beginning of the period.
So comparing a date to PAST_YEAR = 2 would count back 2 years from the current date and rewind to January 1 of that year.
To go back exactly one year use PAST_DAY = 365.
Relevant Documentation:
https://toolset.com/documentation/user-guides/filtering-views-by-custom-fields/
This is the technical support forum for Toolset - a suite of plugins for developing WordPress sites without writing PHP.
Everyone can read this forum, but only Toolset clients can post in it. Toolset support works 6 days per week, 19 hours per day.
| Sun | Mon | Tue | Wed | Thu | Fri | Sat |
|---|---|---|---|---|---|---|
| - | 7:00 – 14:00 | 7:00 – 14:00 | 7:00 – 14:00 | 7:00 – 14:00 | 7:00 – 14:00 | - |
| - | 15:00 – 16:00 | 15:00 – 16:00 | 15:00 – 16:00 | 15:00 – 16:00 | 15:00 – 16:00 | - |
Supporter timezone: Europe/London (GMT+01:00)
This topic contains 4 replies, has 2 voices.
Last updated by kelvinL-2 7 years, 11 months ago.
Assisted by: Nigel.
How can I query the post from today to past 1 year?
For example today is Jun 9, 2016, I only want to query all from Jun 10, 2015 to Jun 9, 2016.
I set the custom date field as number and range is greater than or equal the PAST_YEAR 1.
I have a post on 7 Jun 2015 but it also be filtered and show up.
What is the definition of PAST_YEAR when 1?
Best regards,
Kelvin;
Nigel
Languages: English (English ) Spanish (Español )
Timezone: Europe/London (GMT+01:00)
Hi Kelvin
PAST_YEAR will go back a number of years but will start from 1 January.
If you want to go back one year from today use PAST_DAY with 365 instead.
(Sorry, leap years will drop a day.)
See the attachment.
Nigel
Languages: English (English ) Spanish (Español )
Timezone: Europe/London (GMT+01:00)
