Question

Photo of Greg Leininger

0

Birth Date filter in Data View results in error

I have created a Data View where I want to see people who are missing the birth date value. I set a filter where Birth Date Is Blank. Rock gives me this error:

INFO: There was a problem with one or more of the filters for this data view...

Birth Date Is Blank: String was not recognized as a valid DateTime. 

So, it looks like the SQL was incorrectly written to where it looks for a blank string in a date field rather than a null value in the date field.

  • Photo of David Leigh

    0

    Hi Greg,

    This issue has been fixed and will be available in the next release:
    https://github.com/SparkDevNetwork/Rock/commit/ce13b312649f9331007a35ddfb8010976efbad0a