Re: Workdays function with Australian Dates
- From: "Arno R" <arraNOcomSPAM@xxxxxxxxxx>
- Date: Fri, 17 Mar 2006 00:32:58 +0100
"RoyVidar" <roy_vidarNOSPAM@xxxxxxxx> schreef in bericht news:mn.84fd7d637ddfdab3.33955@xxxxxxxxxxx
Arno R wrote in message <441967ae$0$23339$ba620dc5@xxxxxxxxxxxxxxxxxxx>
:
So StartDate would become Clng(StartDate) and so on.
Arno, have you tried that number trick on SQL server using ADO?
My guess would be that there would be a difference of a couple of days
when executing something like that on a separate connection to the
server vs on linked tables.
Then, what about upsizing your db to other platforms ...?
--
Roy-Vidar
To be honest I never tried that with ADO.
But I did try that with DAO and ODBC-connections to SQL-server.
Why would ADO make a difference here?
The date-portion of a date-field date is just an integer value isn't it??
Is this not so when using ADO ???
Arno R
.
- Follow-Ups:
- Re: Workdays function with Australian Dates
- From: RoyVidar
- Re: Workdays function with Australian Dates
- From: Lyle Fairfield
- Re: Workdays function with Australian Dates
- References:
- Workdays function with Australian Dates
- From: Dixie
- Re: Workdays function with Australian Dates
- From: Jeff
- Re: Workdays function with Australian Dates
- From: Dixie
- Re: Workdays function with Australian Dates
- From: Arno R
- Re: Workdays function with Australian Dates
- From: RoyVidar
- Workdays function with Australian Dates
- Prev by Date: Called Stored proc Oracle from Access ADODB
- Next by Date: Re: Can it be that NO ONE HERE knows this answer?
- Previous by thread: Re: Workdays function with Australian Dates
- Next by thread: Re: Workdays function with Australian Dates
- Index(es):
Relevant Pages
|
