Tell us what you are trying to do?
I have a Type - Checkin which has a custom field checkin date (format-DATE). I am trying to provide a search for administrators to search for individuals who have checked in between a date range.
Is there any documentation that you are following?
Followed the documentation provided but it's still not working. I have attached a screenshot of the Custom Field Filter and the Search Properties. In the search filter I've tried using Type of control (As defined in types/Date), Compare value as a (Date/number), Using this comparison (between).
I've added the url param below once the search button is clicked: hidden link
All the other filters on the page are working. When I add only the min date filter it provides me all the data. When I add a max filter only, it doesn't show me anything.
Hello. Thank you for contacting the Toolset support.
Can you please share admin access details so I can review the custom search configurations and check whats going wrong with your setup.
*** Please make a FULL BACKUP of your database and website.***
I would also eventually need to request temporary access (WP-Admin and FTP) to your site. Preferably to a test site where the problem has been replicated if possible in order to be of better help and check if some configurations might need to be changed.
I have set the next reply to private which means only you and I have access to it.
It seems you have imported the data to your custom fields - is this correct?
The thing is that Types date field stores the date value as Unix Timestamp , so when you import the data to Types date field, the date value should be imported as Unix Timestamp.
If you see the following post:
- hidden link
The checkin date shows as today's date and just below it you will notice that the value for the field "wpcf-checkin-date" is shows as date i.e. 2021-03-08 03:54:12.
So, can you import the date values as Unix Timestamp and make sure that the checkin data custom field shows the correct date value instead of today's date.
