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...
 
Back
Top