My quarter to date calculation is returning incorrect results. I want to show QTD records for all years. My calculation is returning all records for Q4 for previous years. I only want records from 10/1/17 to 10/31/17 (This will be QTD as of October), for example.
I have a date calculation "Dateadd" that returns end of last month: DATE(DATEADD('day',-1, DATETRUNC('month', TODAY())))-- This returns 10/31/2018