Date Parameter when using Intl Date Formats

[Lauren Quantrell]

I already figured out (the hard way) I need to convert all my date
parameters into USA format before executing my stored procedures where
dates are used as parameters.
(Format(StartDa te, "m/d/yyyy hh:nn:ss AM/PM")

At least I thought I did!

But then I discover that if I use the following construction, the dates
do not need to be formatted to USA first:

Dim StartDate as Date, EndDate as Date

StartDate = Date()
EndDate = Date() +1

cmd.Execute , Parameters:=Arr ay(StartDate, EndDate),
Options:=adExec uteNoRecords

Am I smoking dope here or did our MS friends make this more confusing
than necessary?

[Lyle Fairfield]

I wrote one reply and removed it.
Input Parameters have been, for me, very gnarly things.
I have been most successful when remembering that they must be strings
which MS-SQL can understand.
So what will
@StartDate = Date()
return? I don't know. On my computer it returns
@StartDate = 2005-11-28
MS-SQL (or Access) doesn't know that I want it to convert 2005-11-28 to
a date. But it will handle
'2005-11-28'
and
#2005-11-28#
and I expect it will also handle the dates expressed as
#mm/dd/yyyy#

[Terry Kreft]

The easiest way to handle passing dates to SQL Server is to pass it in one
of the formats which Convert understands, then immediately convert it to a
datetime variable.

So for instance you could pass a date in international format.

Format(Date, "YYYYMMDD")

and then in your SP

Create Procedure usp_some_proc
@indate varchar(10)
AS
Declare @real_date datetime

Select @real_date = Convert(datetim e, @indate, 112)
-- Then you can just work with @real_date and not worry about the format


--
Terry Kreft

"Lyle Fairfield" <ly***********@ aim.com> wrote in message
news:11******** **************@ g47g2000cwa.goo glegroups.com.. .

I wrote one reply and removed it.
Input Parameters have been, for me, very gnarly things.
I have been most successful when remembering that they must be strings
which MS-SQL can understand.
So what will
@StartDate = Date()
return? I don't know. On my computer it returns
@StartDate = 2005-11-28
MS-SQL (or Access) doesn't know that I want it to convert 2005-11-28 to
a date. But it will handle
'2005-11-28'
and
#2005-11-28#
and I expect it will also handle the dates expressed as
#mm/dd/yyyy#