Date format for Search page stored search?

Squiz Matrix Support
1

Hi,


I'm trying to setup a stored search for a search page which searches on assets metadata fields which are Date type.



Would someone know what format the value of the stored search variable needs to be?



What I'm trying to do is set a default stored search of todays date, using %globals_date% in the stored search.



Looking at the HTML form that the search page generates, I would have thought that the format would be dmY (eg for 20 Sep 2010, it would be '2092010') but that doesn't seem to work…?





thanks,

Maks.

2

Perhaps have a look at what the format is that the search page generates (in the GET variables) if you were to type it in to a search field? Then copy that… (sorry, I don't know off the top of my head).


If it's not in the right format, maybe the ^date_format keyword modifier could help you…

3

[quote]
Perhaps have a look at what the format is that the search page generates (in the GET variables) if you were to type it in to a search field? Then copy that… (sorry, I don't know off the top of my head).



If it's not in the right format, maybe the ^date_format keyword modifier could help you…

[/quote]



Thanks Dan. The problem is that the search page actually uses 3 separate html input elements per each date and what I cannot figure out is how these 3 inputs needs to be combined/formatted into 1 string to be used in the search page assets "stored search" parameters.



Maks.

4

[quote]
Thanks Dan. The problem is that the search page actually uses 3 separate html input elements per each date and what I cannot figure out is how these 3 inputs needs to be combined/formatted into 1 string to be used in the search page assets "stored search" parameters.



Maks.

[/quote]



I know this is yonks ago but I'm running into the same problem. We're on Matrix v4.2.2 so don't have access to the Calendar Events Search Page (not sure if that would solve our issue, anyway?).



I have a Search Field set up for a Recurring Calendar Event end_date. When I add that as a Stored Query Location using Set Value I only have one text box to enter what is normally at least 6 values. Our full search page query string for a date range looks like this:

queries_endlaststopdate_query_fromvalue[d]=1&queries_endlaststopdate_query_fromvalue[m]=1&queries_endlaststopdate_query_fromvalue[y]=1992&queries_endlaststopdate_query_tovalue[d]=31&queries_endlaststopdate_query_tovalue[m]=12&queries_endlaststopdate_query_tovalue[y]=2012



In in what format do I need to enter those 6 values into the Set Value field in Stored Search?



EDIT: Another option is for us to list all Recurring Calendar Events as the default search but I've set Stored Search Options Show the Results Page to 'Yes' and on the Search Fields screen have set Allow Empty Searches to 'Yes' but accessing the search page directly gives no results. Any thoughts?



EDIT2: I got the 'all results' option working but it doesn't display what the date range we'd like to see as the heading so that's not a solution, unfortunately.