Question
June 28, 2007 at 05:57 AM
the32ndchair

Acces Date

by the32ndchair . Updated 19 years, 2 months ago

I am trying to get a check box to check if the date is within 90 days, 60 days, or 30 days. It seems to work but for some reason Feb does not come up right. Here is the code I am using.

=(DateDiff(“yyyy”,([Evaluation Date]-30),Date())*365)-DateDiff(“d”,([Evaluation Date]-30),Date())<=0 Any help would be great. Thanks

This discussion is locked

All Comments