Shane T. McFarland on 04 Jun 2018 21:14:15
I deal with sales volumes often and base query logic on 'this month' or 'last month' and so on. Unfortunately, when I am developing on the first of the month, I am unable to Pivot or work with any columns for this month until those specific tables have data in them a few days later. If I could somehow tell Desktop to treat the day like a specific day [say last day of month] I could continue developing with example data.