1 Reply Latest reply: Jul 2, 2013 7:43 PM by Alan Farrell RSS

    Input date variable - 1 year , syntax

    Bradley Coyne

      hi.

       

      i have an application whereby i have two date input variables .

       

      VDate_From - 2013-01-01

      VDate_To - 2013-04 -04

       

      i wish to be able to do an analysis whereby i can also see the exact difference between the period of  - 1 year.

       

      Date from - 2012-01-01

      Date to  - 2012-04-04

       

       

      2013 - 01 - 01 - 2013- 04 - 04
      2012 - 01 -02 - 2012 -04 -04
      100 USD98 USD


       

       

      i have used the following statement  -

      Sum(if(Faktdatum>=VDate_From -365 and Faktdatum<=VDate_To -365,Nettobelopp))

       

      however i receive the following

       

      2012-01-02- 2012-04-04

       

      any clue how to match the days exactly example 2013 -01 -01  <------> 2012-01-01??

       

      Best,

      Brad