How can we filter based on only month and day using queryFilter?

Note if the database side VIEW method is utilized on a datetime value, any DB-side calculations to return DAY, MONTH and YEAR separately will be done on those GMT values and may be incorrect depending on the time of day in the value, as Appian's time zone conversions are bypassed with this method.  To resolve this, we implemented the solution from mssqltips.com to convert GMT, with daylight savings, and it works great as we always report in Eastern time.  The datetime values are wrapped in that function call, within SQL's DATEPART() function.

Note if the database side VIEW method is utilized on a datetime value, any DB-side calculations to return DAY, MONTH and YEAR separately will be done on those GMT values and may be incorrect depending on the time of day in the value, as Appian's time zone conversions are bypassed with this method.  To resolve this, we implemented the solution from mssqltips.com to convert GMT, with daylight savings, and it works great as we always report in Eastern time.  The datetime values are wrapped in that function call, within SQL's DATEPART() function.