Input date variable - 1 year , syntax

Tue, 02 Jul 2013 21:18:44 GMT

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

Re: Input date variable - 1 year , syntax

rustyfishbones — Tue, 02 Jul 2013 23:43:37 GMT

Try the Qlikview date and time series on YouTube

This video may help you