Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

matarassi
New Contributor

Duvida DateDiff

Alguém sabe me dizer se esta informação procede?

infelizmente o QV não tem uma função pronta que calcula o número de meses entre duas datas, como por exemplo o DateDiff() do SQL...

4 Replies
Highlighted
prma7799
Honored Contributor III

Re: Duvida DateDiff

You can try like this

Num(Year(Date1)) - Num(Year(Date2)) --> gives the Yeardiff

Num(Month(Date1)) - Num(Month(Date2)) --> gives the Monthdiff

Num(Week(Date1)) - Num(Week(Date2)) --> gives the Weekdiff

Num(Date1) - Num(Date2)) --> gives the Daydiff

prma7799
Honored Contributor III

Re: Duvida DateDiff

matarassi
New Contributor

Re: Duvida DateDiff

Thanks. Not sucess. Only with DateDiff in SQL.

Marco A. Matarassi

2017-08-09 4:36 GMT-03:00 P M <qcwebmaster@qlikview.com>:

prma7799
Honored Contributor III

Re: Duvida DateDiff

What difficulties are you facing ..

Share some sample app with expected output.