Finde dato mellem to dato felter i db

DU kan bruge funktionen Datediff

krasmussen, har du en ide om hvordan jeg skal gøre det?

sider med en asp side, hvor jeg har dags dato, date(), og skal så finde den række i tabellen hvor dags dato falder inden for.

Guro.Not

The date format (Short Date) is only used for displaying the date, it has nothing to do with how the date is stored in the dB!


You can try this, although I am not sure if it will work if you areusing it in ASP

Select * From TUR_LISTE Where Clng(date) Between Clnh([FRA_DATO]) And Clng([TIL_DATO])

little error there!

Select * From TUR_LISTE Where Clng(date) Between Clng([FRA_DATO]) And Clng([TIL_DATO])

Select * From TUR_LISTE Where Clng(date()) Between Clng([FRA_DATO]) And Clng([TIL_DATO]);

Tabellen inde holder

TUR_ID, TUR_NAVN, FRA_DATO, TIL_DATO
1, 501    14-06-2003, 13-12-2003
2, 501    14-12-2003, 05-06-2004
3, 502    14-12-2003, 05-06-2003
4, 502    14-06-2003, 13-12-2003

Select * From TUR_LISTE Where Clng(date()) Between Clng([FRA_DATO]) And Clng([TIL_DATO]);
Retuner:

3, 502, 14-12-2003, 05-06-2003
4, 502, 14-06-2003, 13-12-2003
1, 501, 14-06-2003, 13-12-2003

Den holder da ikke helt. date() ligger da ikke inden for....
Eller er jeg helt galt på den...
Guro.Not

Åhhhhh jeg er dum....

Terry, you er right....THANKS...

Guro.Not

What I am doing here is actually converting the date to a long integer
Clng(). There is no guaranty that this will work with other database formats than Access

okay terry.. is works for me :-)

Select * From TUR_LISTE Where (TUR_ID = 1) And (Clng(Cdate('02-12-2003')) Between Clng([FRA_DATO]) And Clng([TIL_DATO]));

I have modefied the Clng(date()) in to Clng(Cdate('02-12-2003')) to make it work

Guro.Not

Ok! But be carefull with your date!

'02-12-2003'
It may get converted to a date but IS it 2nd December or 12th February?

If you use yyyy-mm-dd it has a better chance of working!

Thanks Terry

:-)