You are viewing limited content. For full access, please sign in.

Question

Question

How to search a range of date using wildcards?

asked on December 29, 2015 Show version history

I tried to create a customize quick search as following.

({[]:[Date]="%(SearchTerm)"})

and wish to use this customize quick seach for seaching a range of dates using wildcards on quick search bar,

But I got an error message after the test.

Is it possible using wildcards with date format or is there any better way to do this?

Thanks in advance.

0 0

Replies

replied on December 29, 2015

Wildcards are not legal in places where the search engine expects a date value.  You can specify a range like:

    {[]:[Meeting Date] >= "2015/12/01" , [Meeting Date] <= "2015/12/31"}

1 0
replied on December 29, 2015

Thanks, Brian.

It seems we can't specify a sketch date value using wildcards.

And what if I specify a range like,

{[]:[Meeting Date] >= "%(SearchTerm)" , [Meeting Date] <= "%(SearchTerm)"}

Is this works for a customize quick search?

 

I found that this scenario works pretty good with text field like:

({[]:[Name]="%(SearchTerm)"})

Because I can use a wildcards value in a quick search field without any error.

Then how to create a customize quick search using unpredictable date value for input and return a range of dates for output?
Please suggest a solution for this issue.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.