topic Re: datediff in QlikView

datediff

Wed, 17 Sep 2014 07:49:07 GMT

hi all,

how can i determine the difference in months between two given dates (in LOAD script) where the first date would always be the 1st month and the second date always be the nth month after the first date. example:

date 1: 2012-03-15

date 2: 2013-01-04

diff: 10

many thanks for some help!

Re: datediff

anbu1984 — Wed, 17 Sep 2014 07:58:46 GMT

Load DIV(Date#(date2,'YYYY-M-D') - Date#(date1,'YYYY-M-D'),30)+1;

Load * Inline [

date1,date2

2012-03-15, 2012-04-04 ]

Re: datediff

MK_QSL — Wed, 17 Sep 2014 07:59:00 GMT

=Month(Date#('2013-01-04','YYYY-MM-DD')) + Year(Date#('2013-01-04','YYYY-MM-DD'))*12 - (Month(Date#('2012-03-15','YYYY-MM-DD')) + Year(Date#('2012-03-15','YYYY-MM-DD'))*12) as DateDifference

=Month(Date#(DATE2,'YYYY-MM-DD')) + Year(Date#(DATE1,'YYYY-MM-DD'))*12 - (Month(Date#(DATE2,'YYYY-MM-DD')) + Year(Date#(DATE1,'YYYY-MM-DD'))*12) as DateDifference

Re: datediff

anbu1984 — Wed, 17 Sep 2014 08:00:23 GMT

How Do I Get the Number of Months Between Two Dates?