Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Comparing dates

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?

1 Solution

Accepted Solutions
sunny_talwar

May be try this:

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

View solution in original post

2 Replies
trdandamudi
Master II
Master II

Hope this is what you are looking for:

Comparing_Dates_18_Jan_2017_01.jpg

Check you date formats as below:

Comparing_Dates_18_Jan_2017_02.jpg

sunny_talwar

May be try this:

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