Svær sqlstreng

WHERE Left(AlarmOn,10) = 'Hej med dig'

?
Why do you need to use Left() on a date field?

Terry do you understand danish

Jeg har et felt med "dato - tid" hvor jeg vil søge mellem 2 datoer uden tid.

Jeg skriver eks 01-01-2003 til 23-12-04 alså uden tid

Yes I understand Danish 99.99%

If it is a date time field and with an Access database try this

" ...... Between #" & Format([FirstAlarmDate], "yyyy-mm-dd 00:00:01") & "# AND #" & Format([LastAlarmDate ], "yyyy-mm-dd 23:59:59") & "#"

or somethng like that

Ville det ikke være lidt smartere at lave 2 felter, et med dato og et med klokken, og så evt sammensætte det når du viser data

this makes sure that your time part is between the dates

baldurn why have two field when one is enough?

Another method (if is Access)

" ....where Long(AlarmOn) Between " & Long(FirstAlarmDate ) & " AND " & Long(LastAlarmDate)

Problemet er at jeg ikke lige kan dele det op i to felter, da der er en masse programmering til den aktuelle database

No need to split it into two fields!

Little problem I think with the last example! (I'm not testing)

" ....where Long(AlarmOn) Between " & Long(FirstAlarmDate ) & " AND " & Long(DateAdd("d",1,[LastAlarmDate]))

Kan man lave en søgning med et Joker tegn noget ligende

X txtsql.Text = "SELECT AlarmID, AlarmNr, AlarmNavn, AlarmText,AlarmOn, AlarmReset, AlarmKvitt, AlarmKvittNote FROM Alarmlog WHERE AlarmNr >= 0 And AlarmOn Between " & 'FirstAlarmDate'% & " And " & 'LastAlarmDate'% & " order by AlarmID DESC"

FirstAlarmDate eks 01-01-2002
LastAlarmDate eks 01-03-2004

Format i database AlarmOn = 01-01-2002 - 23:59:16

Lidt oplysninger

edl>Which database are you using?

Terry hvorfor Long(xxx)

have you tried the example I gave 13/02-2004 21:31:03 ?

Access

If you are using Access a date field is contained in the dB as a long

Oops, I'm falling asleep here :o)

change long() to clng() which converts the date to a long

OK, in Access a date is contained in the dB as a long number NOT as 01-01-2002 - 23:59:16 This is only how you see that date!

If you work with dates in an SQL then the date has to be inside ##

Example #2003-02-02#

but if you convert it to a long using clng() the it isnt necessary

You should try the example I gave 13/02-2004 21:31:03

Jeg prøver at programmeren 13/02-2004 21:31:03

Jeg vender tilbage om lidt

Terry DU ER EN GUD 60 til dig Smart at lave format med tid som et helt døgn
Mange tak for hjælpen .-)

So I'm guessing that it works :o)

og selv tak.

Now I'm off to see some TV

Tak igen

I think you need to accept the anwer edl!

Og god weekend

tak