Comparing dates

[#1]

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]

Hope this is what you are looking for:

Check you date formats as below:

[sunny_talwar · Accepted solution]

May be try this:

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