Elasticsearch lucene regex issues


I am trying to extract the particular field which has any-date value. the filed name is last_state_change.

Date appears in this format - > 1970-01-18 16:05:43

i have written regexp to parse the date for the above format, which is correct “([0-9][0-9][0-9][0-9])-([0-9][0-9])-([0-9][0-9]) ([0-9][0-9]):([0-9][0-9]):([0-9][0-9])”

Screen Shot 2017-06-21 at 5.18.28 PM

But when i use the same regexp in the lucene query box, i dont see any data.

Screen Shot 2017-06-21 at 5.20.29 PM

can some one guide me on this ?

When i use /@/ i can see, my intention is to filter the field which has only date. i want to ignore if it doesnt have date.

Screen Shot 2017-06-21 at 5.22.05 PM

last_state_change = asdasdsa

this is not valid lucene syntax. checkout the Elasticsearch docs on how to search and filter using lucene.

thanks torkel.

it suppose to be last_state_change: