4 Replies Latest reply: Dec 14, 2015 3:15 PM by Rich Owen RSS

    Dates

      I need to create a total (sum) based on a specific date and using the following function:

      Sum({PositionDailySnapshot.SnapshotDate = {"=date($(varMaxDateNumber))"}>}[PositionDailySnapshot.FirmCurMarketValue])


      I am getting no results - looks like the date format is 02/28/2014