Can someone please advise me why I can't use this as a SQL Filter?
| "Gregorian Calendar"."Date" = TIMESTAMPADD(SQL_TSI_DAY , -(1), TIMESTAMPADD(SQL_TSI_DAY , DAYOFMONTH("Gregorian Calendar"."Date") * -(1) + 1, "Gregorian Calendar"."Date")) |
When I put the expression in a formula it returns the correct date 12/31/2018 .... but it doesn't work as the criteria for a filter...
Similarly I would also like to filter on the last day of the previous year. Can someone please assist me? Thank you.