default date > field date

[bsbernabe]

Hello There,

how to use this kind of function in QlikView

IF(06/30/2020 > FieldDate, "yes" the also

IF field A- (MONTHS BETWEEN 06/30/2020 - FieldDate) == REM, "CURRENT"
ELSE "FUL"

Thanks

Bing

[rubenmarin · Accepted solution]

Hi, the question is somewhat cryptical, so the answer it's also some to get as an idea:

If(Date('06/30/2020')>FieldDate
  ,'yes'
  ,If(fieldA-((Year(FieldDate)*12+Month(FieldDate))-(2020*12+6))=REM
    ,'CURRENT'
    ,'FUL'
))

[bsbernabe]

Hello There,

Thank you so much for the solution You've shared.

Best Regards.