Query won't return results when comparing a datetime to a string

Open Q & A Querying your data
1

:question:Let’s say you have a query like this:

SELECT COUNT(*) from FerroHistory where FerroHistory.RSDate >= '2021-01-01T00:00:00'

Where FerroHistory.RSDate is a Datetime obj.

:no_entry:This query won’t return results because you’re comparing 2 different objects: a datetime obj with a string: '2021-01-01T00:00:00'
You can’t implicitly convert so you will have to use a function to convert the string to a datetime obj.

:white_check_mark: The iso 8601 string in this example can use this function to convert it to a datetime obj: PARSE_DATETIME_ISO8601