Date problem with access

  • Thread starter Thread starter Totto
  • Start date Start date
T

Totto

Hi,
I'm using Access with a dataadapter, and I have to use two different
commandtexts for the application to work on to different computers.
Her are the to Commandtexts:
a)
dadOverdueMonthEvents.SelectCommand.CommandText = "Select
Navn,Beskrivelse,Forfaltdato, sett,Settdato,settav,prioritet from Forfalte "
& _
"Where forfaltdato between #" & DateRange1 & "# and #" & DateRange2 & "# " &
_"Union " & _
"Select Navn,Beskrivelse,Forfaltdato, sett,Settdato,settav,prioritet from
Historie " & _
"Where forfaltdato between #" & DateRange1 & "# and #" & DateRange2 & "# " &
_
" and not utfortdato between #" & DateRange1 & "# and #" & DateRange2 & "#"

b)
dadOverdueMonthEvents.SelectCommand.CommandText = "Select
Navn,Beskrivelse,Forfaltdato, sett,Settdato,settav,prioritet from Forfalte "
& _
"Where forfaltdato between '" & DateRange1 & "' and '" & DateRange2 & "' " &
_
"Union " & _
"Select Navn,Beskrivelse,Forfaltdato, sett,Settdato,settav,prioritet from
Historie " & _
"Where forfaltdato between '" & DateRange1 & "' and '" & DateRange2 & "' " &
_
" and not utfortdato between '" & DateRange1 & "' and '" & DateRange2 & "'"

On the computer I'm developing on it's working with commandtext a and not
with b, on the testcomputer it's the other way around.
Both computers have MDac 2.8 installed.

Anyone know what's the problem here..

TNX
 
Hi Totto,

I bet it relates to regional settings.
You migh format the data to DateRange1.ToString("M/d/yyyy") and embed it
into ##.
 
Back
Top