I'm trying to compare dates in my database to see whether the record is from a recent report; can anyone help me detect dates which are recent.

[#1]

I'm trying to compare dates in my database to see whether the record is from a recent report; can anyone help me detect dates which are recent. I've tryed creating an the following expression

=IF(alt(Date#(ClosePeriod,'DD-MM-YYYY'))>=Date(Today()-7),'Recent Report')

But I just get NULLs

[Gysbert_Wassenaar]

Your alt function is missing an else parameter. You didn't specify an alternative value. Try =IF(alt(Date#(ClosePeriod,'DD-MM-YYYY'),0)>=Date(Today()-7),'Recent Report')

[#3 · Accepted solution]

Thanks Adding the ELSE element (see below) makes this work.

=IF(alt(Date#(ClosePeriod,'YYYY-MM-DD'))>=Date(Today()-7),'Recent Report','Old')