# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Contributor

## Flag help

Hi Experts,

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.

1 Solution

Accepted Solutions
New Contributor III

## Re: Flag help

@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,

3 Replies
New Contributor III

## Re: Flag help

@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,

Contributor III

## Re: Flag help

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

Highlighted
Valued Contributor III

## Re: Flag help

Hi,

can you try something like

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