There are two sides to this request, firstly how to get your date looking field to be an actual date, and then how to format cells related to comparisons based upon that date field. For the latter part, see this answer.
For the first part, you’ve got two options, and that is either to switch to a proper date format like YYYY-MM-DD which is interpreted as a date by default, or you’ve got to transform your text into a date.
Something like the following should work to transform it into a date (although I would strongly consider to change into a proper date format):
```dataview
TABLE Deadline, deadlineDate
FLATTEN date( regexreplace(Deadline, "(\d{2})(\d{2})(\d{2})", "20$1-$2-$3") ) as deadlineDate
FROM [[⛰️ Admin]] and #🚧/🟨
SORT Deadline asc
```
And if combined with the CSS stuff from the other answer, you could get a somewhat more complex query like the following:
```dataview
TABLE
"<span class='" + cellClass + "'>" + deadlineDate + "</span>" as Deadline
FROM [[⛰️ Admin]] and #🚧/🟨
FLATTEN date( regexreplace(Deadline, "(\d{2})(\d{2})(\d{2})", "20$1-$2-$3") ) as deadlineDate
FLATTEN
choice(deadlineDate > date(now), "cellOK",
choice(deadlineDate = striptime(date(now)), "cellWARN",
choice(deadlineDate < date(now), "cellLATE", ""))) as cellClass
SORT deadlineDate asc
```
Which with (almost) the same data as you presented in your image, would produce something like:
PS! Mouse insurance?! Why do you insure your mice?! And from what? 