alternatives to now()

[Cereldine]

I have a query based around a persons sick start and return date. A report is based upon this and then this makes up a sub part of management information report that is linked through a formatted month. Part of my report is based around the following formula, this governs which MI report to include it in

repMonth: (IIf(IsNull([returndate]),Format(Now(),"mm/yy"),Format([returndate],"mm/yy")))

This states that if a person has not returned to work then give them a formatted version of now() so it can be linked to the main report. My problem is if i wanted to look at a previous months report and a person has still not returned to work they will have the now() date and thus not be included in a previous months report! Does this make sense, have i gone a really out of the way route to solve my problem and can anyone see a more effective way of carrying out this problem?
thanks in advance, sorry for confussion!

 

[AngelsGuardian]

Maybe you can try and remove the now and replace by Date

repMonth: (IIf(IsNull([returndate]),Format([COLOR="Red"]Date[/COLOR],"mm/yy"),Format([returndate],"mm/yy")))