It would be helpful to have an operator that could be used to convert a text into a date. It is possible at present when using a URL parameter Any pitfalls in using Text field types for storing dates in bubble data tables? - #9 by boston85719 and is therefore not out of the realm of possibility.
The same way that we can format something that turns it to text and then convert to a number we should be able to do that with converting it to a date…may reasons behind this, most notably that when we want to alter the timezone of a date we have to use the formatted as operator which turns it into a text and then we are stuck and can no longer manipulate the values as dates.