topic Re: Comparing dates in QlikView

Comparing dates

Wed, 25 Nov 2020 16:16:04 GMT

I can not make a comparison between two dates. The following snippet shows an example in detail:

"if(fine_anno=finemese,1, 0)"

where:

fine_anno = 31/12/2016

finemese = 31/12/2016

-----------------------------------

fine_anno = 31/12/2016

finemese = 30/04/2016

By obtaining, for any comparison, always "0". Where am I doing wrong?

trdandamudi — Wed, 18 Jan 2017 10:21:47 GMT

Hope this is what you are looking for:

Check you date formats as below:

sunny_talwar — Wed, 18 Jan 2017 10:38:04 GMT

May be try this:

If(Floor(fine_anno) = Floor(finemese),1, 0)