Is there a way to compare against results of regexmatch?

[aravindk100]

I am using this query (WHERE regexmatch(".\d{4}-\d{2}-\d{2}.",text) ) to pull out all tasks which has a date in it but not necessarily defined as inline variable. Is there a way to compare the results of this regexmatch against an actual date? When I tried to add comparison operators at the end of it I didn't get anywhere.

TASK
WHERE !(contains(text, "[do::") OR contains(text, "[due::"))
WHERE regexmatch(".\d{4}-\d{2}-\d{2}.",text)
WHERE !completed

[AB1908]

I think you're looking for type casting here. You should be able to extract the text and then cast that to a date with date(extracted_text).