hi,

i passed a date variable (eg variable name = salesdate, format = 2005-07-03) to my stored proedure and it does not work.

however it works when i put the function curdate() in place of the variable.

what can i be doing wrong?

A few questions:
- What's the exact error?
- What's the definition of the Stored Procedure?
- Where does it fail (in the Pervasive Control Center or your application or both)?
- What's the actual command to call the procedure that you're using?

One suggestion:
- Make sure the date is formatted properly (YYYY-MM-DD). It also needs to be enclosed in single quotes ('2005-03-07').