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 USD | 98 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
