8 Replies Latest reply on Sep 14, 2018 6:01 AM by Megha Tanwar

    comparing date from data with a date from Parameter

    Megha Tanwar

      Hi,

       

      I am trying to compare my date with the given by user. Something like this - IF [Choose Start Date] =[INVOICEDATE] THEN [Sales] ELSE 0 END.

       

      But the the results are always coming to zero. Then i tried doing - IF Month([Choose Start Date] )=Month([INVOICEDATE]) -  THEN [Sales] ELSE 0 END which works but  with year it does not works IF YEAR([Choose Start Date]) = YEAR(INVOICEDATE) THEN [Sales] ELSE 0 END

       

      Looking for quick answers. Thanks