I'm using DateTime in my model, but when I use simple date formats like '1-1-2020' in my queries, they fail validation. Why is that? The back-end date may contain both a date and a time, but like any other query language I want to be able to query these fields with simple date formats or with more specific DateTime formats. Why can't I query a DateTime with a Date?
I'm trying to figure out the best way to accomplish the above and having some trouble with it. Any advice?
I'm using DateTime in my model, but when I use simple date formats like '1-1-2020' in my queries, they fail validation. Why is that? The back-end date may contain both a date and a time, but like any other query language I want to be able to query these fields with simple date formats or with more specific DateTime formats. Why can't I query a DateTime with a Date?
I'm trying to figure out the best way to accomplish the above and having some trouble with it. Any advice?