query time

[maxmekk]

Hi



When trying to query specific time interval I seem to fail. I hope some you guys maybe have a good suggestion on this.

I store information on date and time in the same field:

19.01.2014 19:42:00
19.01.2014 20:35:00
19.01.2014 23:36:00
20.01.2014 03:30:00

I would like to query for all times between 00:00:00 and 06:00:00

between #00:00:00# and #06:00:00#

seems not to be working

Any suggestions?

Sincerely

Max

[JoeM]

You can create a "helper" calculated field which pulls off just the time piece of the date/time field, i.e.

MyTimePart: TimeValue([MyDateTimeField])

Then, you can use the Criteria on this "helper" field:

Between #12:00:00 AM# And #6:00:00 AM#

[maxmekk]

Will it work with European time standard... 24 hours?

Max

[JoeM]

It should. You might just need to change your Criteria to what you had originally.

I had actually entered the Criteria as you originally set it:

Between #00:00:00# and #06:00:00#

and it automatically changed it to what I posted.

It might just be a regional setting thing, but I think it should work either way.
Of course, there is an easy way to find out, try it and see what happens!