Tidsinterval på datoperiode

Try adding a time to your date/times ans then see what you get

>#21-07-08 23:59:59# And <#30-07-08 00:00:01#

or if you really so want to include both dates

>#21-07-08 00:00:01# And <#30-07-08 23:59:59#

Eller:

>=#21-07-08# And <=#30-07-08#

Periode er:
21-07-08 09:33:45
30-07-08 16:25:25

For denne kunne : >#21-07-08 00:00:01# And <#30-07-08 23:59:59#

Men lige nu forstår jeg ikke, hvorfor mugs løsning ikke fungerer:

If there is a time in the period and you want everything between these dates+time then you need to include them. If you only want dates greater than the start date then inlcude 23:59:59 as the start time and 00:00:01 as the stop time

>= #21-07-08 09:33:45# And <=#30-07-08 16:25:25#

">#21-07-08# And <#30-07-08# Giver udvalg fra og med 21 til 29"


If Access assumes the the time in both cases is 00:00:00 then this would be expected because you records actually contain a date/time value outside of these. To ensure that you get what you want then inlcude the appropriate time.

ok terry.

Hvordan er syntax så i samme datointerval:

>#21-07-08 00:00:01# And <#30-07-08 23:59:59#

Men kun fra og med kl. 09:00:00 til og med 09:59:59

I would think this would work (for same date)

>=#21-07-08 09:00:00# And <=#21-07-08 09:59:59#

Ja, det fandt jeg også ud af.

Prøvede ny kolonne i forespørgselsgitret, hvor tid >=#09:00:00# And <=#09:59:59#. Access tilføjede automatisk år 1899 :o)

Kan man ikke med format eller en anden funktion trække klokkeslæt ud, således at man i en kolonne spørger på datointerval og i en anden kolonne spørger på time/minut/sek. interval?

Ser ud til at virke med start- slutdato med starttid og sluttid:

>#8/1/2008 0:0:1# And <#9/11/2008 23:59:59# AND Format([Dato],"short time")>=#9:0:0# And Format([Dato],"short time")<#10:0:0#

Kan garanteret trimmes - hvad I mugs eller terry?

I'm not at all sure what your trying to do here, can you give an example of your data and what you want to see in the result?

I dont see any reason to have the date and time in different criteria, its just complicating things.

Fordi jeg vil se bevægelser i samme tidsrum hver dag. Her er et eksempel på datoer fra og med den 11 januar til og med 28 januar mellem kl. 16 og klokken 16:59:59

#8/1/2008 0:0:1# And <#9/11/2008 23:59:59# AND Format([Dato],"short time")>=#16:00:00# And Format([Dato],"short time")<#16:59:59#

11-jan-08    16:02    testdata
11-jan-08    16:02    testdata
11-jan-08    16:02    testdata
11-jan-08    16:02    testdata
11-jan-08    16:34    testdata
14-jan-08    16:14    testdata
14-jan-08    16:43    testdata
15-jan-08    16:07    testdata
16-jan-08    16:27    testdata
16-jan-08    16:37    testdata
18-jan-08    16:23    testdata
18-jan-08    16:57    testdata
21-jan-08    16:26    testdata
23-jan-08    16:06    testdata
23-jan-08    16:34    testdata
23-jan-08    16:36    testdata
23-jan-08    16:36    testdata
28-jan-08    16:03    testdata

The date criteria you give wont select any from your test data! And because you only want to see times between 16:00 and 16:59:59 then you will need to have a seperate criteria as you indicate here 14/09-2008 22:20:01
And I dont think it can be made much easier, you have to convert the datetime to a time no matter which way you do it.

Ok terry - læg et svar... :o)

et svar :o)