Date/Time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi There,
I have a query that uses the Date\Time function and
displays it as DD\MM\YY HH:MM:SS. I'm trying to extract
any occurance of where the time is 30 minutes or more,
beyond the field. Does anyone know of the proper way to
do this? Conversly, another option would be to make the
subsequent report display these fields in red...either
way is perfectly acceptable.

Any input would be greatly appreciated!

Thx in advance!
 
What do you mean, where the time is 30 minutes or more? You said you are
using the format DD\MM\YY HH:MM:SS. That is a TIME. 30 minutes or more is
a DURATION. Where is your math coming into the picture?


Rick B


Hi There,
I have a query that uses the Date\Time function and
displays it as DD\MM\YY HH:MM:SS. I'm trying to extract
any occurance of where the time is 30 minutes or more,
beyond the field. Does anyone know of the proper way to
do this? Conversly, another option would be to make the
subsequent report display these fields in red...either
way is perfectly acceptable.

Any input would be greatly appreciated!

Thx in advance!
 
Sorry Rick for not clarifying better.
I have 2 fields (sorry) both are formatted in the same
way. I want to find anywhere the time is 30 minutes or
more from Field A to Field B.

Thanks,

Me
 
Sorry Rick for not clarifying better.
I have 2 fields (sorry) both are formatted in the same
way. I want to find anywhere the time is 30 minutes or
more from Field A to Field B.
Click to expand...

Create a Query with a calculated field:

MinutesElapsed: DateDiff("n", [FieldA], [FieldB])

Use a criterion on this field of
30
Click to expand...


John W. Vinson[MVP]
(no longer chatting for now)
 
Brilliant! Thanks John.

-----Original Message-----
Sorry Rick for not clarifying better.
I have 2 fields (sorry) both are formatted in the same
way. I want to find anywhere the time is 30 minutes or
more from Field A to Field B.
Click to expand...

Create a Query with a calculated field:

MinutesElapsed: DateDiff("n", [FieldA], [FieldB])

Use a criterion on this field of
30
Click to expand...


John W. Vinson[MVP]
(no longer chatting for now)
.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date/time query 1
Date Function in query 3
Get time from DATE/time field? 8
Select time only from a date/time field 8
Date & Time Field 4
Date comparison 2
Date Parameter 7
Query to Update Date 2

Back
Top