topic Re: Duvida DateDiff in QlikView

Duvida DateDiff

Anonymous — Tue, 08 Aug 2017 17:48:01 GMT

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...

prma7799 — Wed, 09 Aug 2017 07:36:21 GMT

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 — Wed, 09 Aug 2017 07:38:10 GMT

or check this

Anonymous — Wed, 09 Aug 2017 12:38:44 GMT

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 — Wed, 09 Aug 2017 12:41:06 GMT

What difficulties are you facing ..

Share some sample app with expected output.