MAS90 - MSAccess & Dates

[ProdOps]

I have created a query in MS-Access that reads the Invoice Header table from MAS90 and selects a group of records by a date range on "InvoiceDate". This works great as long as the dates are hardcoded in the criteria cell.

Example: Between #03/01/02# and #03/31/02#

I need to covert the hardcoded dates to parameters:

Example: Between [BeginDate] and [EndDate]

When I run the parameter query and it asks for the "BeginDate" and "EndDate" variables I get a "Conversion Error" returned from the ODBC driver.

Does anyone have any suggestions on resolving this?

Thanks,
ProdOps

 

[dtrams04]

You might try passing the dates as YYYY-MM-DD.

 

[DaveNewman]

ProdOps-
Wrap the prompts with a CVDate call.

In the criteria cell, put between cvdate([BeginDate]) and cvdate([EndDate])

If you get an error with this, then you are not giving the cvdate conversion function a good value.

Good Luck!

Dave