JQL query to filter a field value

Question

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

mnpiad · Answer

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

Nic Brough -Adaptavist- · Answer

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 · Answer

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 ?