I can't see the underlying queries (the Query Filters) related to those front end filters, but I suspect that the issue is that you are using TODAY() as the default value for both the FROM and TO dates, bearing in mind that the dates used are in UNIX timestamp format (number of seconds since 1 Jan 1970), and so TODAY refers to a single point in time (at 00:00) rather than a range that spans midnight yesterday to midnight today.
If you share some more details about how exactly you want this date filtering to work then we might be able to guide you to the solution.
The post type in this View is "Offline Training Activities". I want the view to allow the person to select a student using a drop down (this part works) and set a date range for when they activities were completed. I want to allow them to pick any start and end dates for the date range. Based on your recommendation I changed the filter to not use Today(). Below is the revised code. It's still not filtering. When the view loads it shows all activities even though the default start/end dates should filter results. When I change the start/end dates it then filters out everything, not showing any results.
[wpv-filter-controls]
[wpv-control-post-relationship ancestors="hr-profiles@student-for-offline-trng-activity.parent" url_param="wpv-relationship-filter"]
<div class="form-group no-print">
[wpv-control-post-ancestor type="select" default_label="Select Student" ancestor_type="hr-profiles@student-for-offline-trng-activity.parent"] Start typing first name to jump to a student in the filter.
</div>
[/wpv-control-post-relationship]
<div class="form-group" style="clear:left;">
<label for="wpv-wpcf-date-completed">[wpml-string context="wpv-views"]Completed From[/wpml-string]</label>
[wpv-control-postmeta field="wpcf-date-completed" default_date="THIS_YEAR()" url_param="wpv-wpcf-date-completed-from"]
</div>
<div class="form-group">
<label for="wpv-wpcf-date-completed">[wpml-string context="wpv-views"]To[/wpml-string]</label>
[wpv-control-postmeta field="wpcf-date-completed" default_date="PAST_DAY(int)" url_param="wpv-wpcf-date-completed-to"]
</div>
[/wpv-filter-controls]
I have attached an image which shows how the query filter is configured. If it's helpful, I can provide login credentials so you can see how the view is functioning.
One important point to note here is that the values passed through the front-end search fields are not automatically applied when the page with the view loads. The filtering related to those front-end search fields will only apply once the search form is submitted.
(either using the search button or through AJAX, when any input value in any search field changes)
To suggest the best way to achieve this filtering, I'll need to see how these fields and the view is set up in the admin area. Can you please share temporary admin login details, along with the link to the page with this view?
Note: Your next reply will be private and it is recommended to make a complete backup copy, before sharing the access details.
I apologize for the delay, as I had an unusually busy forum queue last week.
I tried to log in to the website's admin area, but, it keeps showing the message:
Invalid username and/or password. After 5 failed login attempts you will be blocked for 5 minutes. (code UOFEL1)
Can you please check the username and password again?
I've removed the existing "Date Completed" field filter from the view "Offline Training Activities" and added it again and it seems to be working correctly, now.
An important point to remember when adding a filter for the 'date' type fields is that the 'compare value as' should be "number" and not the "Date".
( screenshot: hidden link )
I hope this helps and please let me know if you need any further assistance around this.
