Passing through dates to Stored Procedures

[chris_visible]

Hi

I am trying to pass parameters from MS Access to SQL server Stored Procedures. I'm passing a date-formatted value and the formats of the dates are in different orders. I.e. dd/mm/yy > yyyy/mm/dd 00:00:00 000.

Is there a quick reliable method of converting the date as it is passed through?

Many thanks for any help?

 

[Pat Hartman]

Use the Format() function.