ADP Using Calendar Dates

[Jusenkyo]

Hello All

I have a form in an ADP, with two ActiveX Calendars, and a subform based on a function.
This function requires two parameters, @Startdate and @Enddate.
(Can you se where this is going?)

I want the user to be able to select two dates from the calendars, and the requested information to appear on this subform.

So far, I can select the dates, requery the subform, and information is displayed... (using the input parameters bit on the subform).

However, the dates that it displays are wrong.
I am assuming that this has something to do with the way access and SQL server deal with dates differently?

Anyone know if any conversion is needed at all?

Thanks in advance!
J

 

[PHV]

I think SQL Server want the iso format for date:
'yyyy-mm-dd'

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244