JQL query to filter a field value

[mnpiad]

Hello,

I have a custom field called "Create Date" which is a text field  which has values like 02/02/2016.... 03/04/2015 ..04/04/2016  etc . as it is a text filed can i query this to find value in range ?

Like find all values between  02/02/2016 And 2027/2016 ?

if Not can i query to find a string that contain "2016"

i tried using "create date" ~ "/2016" but did not work

is " Create Date " a reseved word ?

Thanks

[Nic Brough -Adaptavist-]

You've answered your own question - a field that is text cannot have a range searcher, it's not got data that can support it.  It's a bit like asking "are those colours between two and four?".  The data does not know it might be searchable.

"create date" ~ 2016 will work, but it's going to pick up the 20th January and so-on.

[mnpiad]

Thanks Nic but i tried running 

"Create Date" ~ 2016  in advance JQL query field but it did not return any data am i still missing something ?

[Nic Brough -Adaptavist-]

Mmm, sorry, that used to work, but now it needs the 2016 to be a word on its own.  It won't find partial words, so 20/3/2016 won't be found.

[mnpiad]

So there is no way we can find the word 2016 ?