Flag help

[mahitham]

Hi Experts,

Can any one please help me to create the below flag.

When Date 1 is greater than or equal to Date 2 then it  has to show 1 else 0. But when Date 1 and Date 2 both are same getting 0 instead of 1. Please help me on this.

Please find the below attached app.

Thanks in advance.

[basildur · Accepted solution]

@mahitham Hi, try this 

=if(num(floor(Date1))>=num(floor(Date2)),1,0)

It's probably because of your date format, if you convert in into a floored numeric value it should work.

Best Regards,

Vlad

[Mauritz_SA]

Hi Mahitham

Vlad is correct. Your date part of the two dates are the same, but your timestamp of Date2 is bigger. I checked and if(Floor(Date1)>=Floor(Date2),1,0) also works without converting to a number.

Regards,

Mauritz

[mdmukramali]

Hi,

can you try something like 

=if(floor(Date1)>=floor(Date2),1,0)