[Skip to main content](#vessel-content)

#   Filter on date

##

- **[ralphk](/forum/user/34763-ralphk "View ralphk's Profile")**
- [![ralphk's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/34763-ralphk "View ralphk's Profile") Topic Author
- [ Offline](/forum/user/34763-ralphk)

Less More

- Posts: 9
- Thank you received: 0
-
-

12 years 2 weeks ago [\#178400](#178400) by [ralphk](/forum/user/34763-ralphk "View ralphk's Profile")  *[Filter on date](/forum/45-filters-search/872818-filter-on-date#178400 "-- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.3.6  Hi,  I'm trying to get my products filtered on date. It's a list of trainings, each training has it's own date (added to the product as a custom field, simple date). The cursor option doesn't work, I cannot slide the square along the timeline. Nor does the check in option. Only option that I have left is ordering descending or ascending. But I want people to be able to select a specific date.  Can you help me to create the select option for one specific date (chosen by the customer) or a range of dates that works? Please, step by step tutorial would be very useful :)")* was created by *[ralphk](/forum/user/34763-ralphk "View ralphk's Profile")*

-- HikaShop version -- : 2.3.4
-- Joomla version -- : 3.3.6

Hi,

I'm trying to get my products filtered on date. It's a list of trainings, each training has it's own date (added to the product as a custom field, simple date).
The cursor option doesn't work, I cannot slide the square along the timeline. Nor does the check in option. Only option that I have left is ordering descending or ascending. But I want people to be able to select a specific date.

Can you help me to create the select option for one specific date (chosen by the customer) or a range of dates that works? Please, step by step tutorial would be very useful ![:)](/media/kunena/emoticons/3.png ":)")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzg3MjgxOC1maWx0ZXItb24tZGF0ZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Jerome](/forum/user/80-jerome "View Jerome's Profile")**
- [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile")
- [ Offline](/forum/user/80-jerome)
- HikaShop core developer

Less More

- Posts: 26401
- Thank you received: 4081
-
- [](http://obsi.dev)
-

12 years 2 weeks ago [\#178403](#178403) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Filter on date](/forum/45-filters-search/872818-filter-on-date#178403 "-- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.3.6  Hi,  I'm trying to get my products filtered on date. It's a list of trainings, each training has it's own date (added to the product as a custom field, simple date). The cursor option doesn't work, I cannot slide the square along the timeline. Nor does the check in option. Only option that I have left is ordering descending or ascending. But I want people to be able to select a specific date.  Can you help me to create the select option for one specific date (chosen by the customer) or a range of dates that works? Please, step by step tutorial would be very useful :)")*

Hi,

Using the simple date picker it won't be possible.
The simple date picker store the date in text in the database. So if you want to make some special database operations ; it will be difficult.
You can use a sort if you are using the correct format stored in the database "%Y-%m-%d". Otherwise the sort won't work properly.

By using the "advanced date picker" (if not available, you'll need to publish the associated plugin) ; it will be easier.
The advanced date picker store the timestamp in the database, so it will be easier to make some database operations.
The sort will sort by default.

But the filtering system as not been design to work with these custom fields (simple or advanced date picker).
Which means that you can have something with dynamic values (we planned to make a refactoring on the filter system but it won't be available in a short time delay).
It is possible to modify the filtering system in order to add the compatibility with he date (using the advanced date picker) ; it will require some time and some PHP/development knowledge but it's possible.

Regards,

---

Jerome - Obsidev.com
HikaMarket &amp; HikaSerial developer / HikaShop core dev team.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzg3MjgxOC1maWx0ZXItb24tZGF0ZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop Install &amp; Update Product &amp; Category Display Content Creation Sales and Orders Orders management Reports &amp; Statistics Customers Checkout Payment Methods Shipping Methods Import &amp; Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel &amp; Slider Mass Actions Filters &amp; Search Discount &amp; Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to?

[](/forum/topics/feed/mode-topics?format=feed&type=rss)

Time to create page: 0.093 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
