L
lilbit27
have a query and one of my fields is a date.
in the criteria i put <=DateAdd("m",-2,[rptdt]) so that it will
automatically give me everything that is 60 days past. my problem is
february stops on the 28th so it didn't pull 12/29-12/31 dates when
pulling everything 60 days past feb 28.
Does anyone know how to fix this?
in the criteria i put <=DateAdd("m",-2,[rptdt]) so that it will
automatically give me everything that is 60 days past. my problem is
february stops on the 28th so it didn't pull 12/29-12/31 dates when
pulling everything 60 days past feb 28.
Does anyone know how to fix this?