Hey guys,
I've asked this question before, but need to ask it again b/c of some changes. I made a database in 97 and now I have to convert it to Office/Access XP. In my query, the user enters a report start date in the form mm/dd/yyyy (can be ANY date). What I need to do, is pull records from one table that are minus 1 month from the date they entered, through the future. These records I'm pulling all have start dates that are the 1st of every month (ie. 7/1/02). In Access 97 I used the following:
((tblEntitlement.BeginDate)>=CVDate(Format(DateAdd("m",-1,[Enter start date]),"mm/""01""/yy"
))
This worked wonderfully in 97. When I converted the database to XP and ran the query, I get the error message that the "format function is not recognized/found/whatever". A co-worker and I tried to figure out how to fix this, but no matter what we tried using, the "-1 month" part isn't working- it only gives records from the date entered to future.
Anyone have a solution?? Thanks in advance!
Shivani
I've asked this question before, but need to ask it again b/c of some changes. I made a database in 97 and now I have to convert it to Office/Access XP. In my query, the user enters a report start date in the form mm/dd/yyyy (can be ANY date). What I need to do, is pull records from one table that are minus 1 month from the date they entered, through the future. These records I'm pulling all have start dates that are the 1st of every month (ie. 7/1/02). In Access 97 I used the following:
((tblEntitlement.BeginDate)>=CVDate(Format(DateAdd("m",-1,[Enter start date]),"mm/""01""/yy"
))This worked wonderfully in 97. When I converted the database to XP and ran the query, I get the error message that the "format function is not recognized/found/whatever". A co-worker and I tried to figure out how to fix this, but no matter what we tried using, the "-1 month" part isn't working- it only gives records from the date entered to future.
Anyone have a solution?? Thanks in advance!
Shivani
