Hi All, does anyone know why I get two different results when I use the following codes:
Count({$<
Fault_Closed_Day={">=$(=DATE(Today()-366))"},
Fault_Closed_Day =-{" "},
SLA_Flag= {'N'},
SA_Flag = {'Y'}
>}Fault_Ref)
or
Count({$<
Fault_Closed_Day={">=$(=DATE(Today()-366))"},
SLA_Flag= {'N'},
SA_Flag = {'Y'}
>}Fault_Ref)
I though the code would give the same results since the first one is saying the fault closed date must be greater than or equal to 366 days ago and not blank, the second one says that but without the not blank part.
