DateDiff with a Field Value and a Constant

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

Guest

Hello,

I'm sure I'm missing something super easy. How does one calculate the
number of minutes between a field in a Query "ActualDateTime", and a
semi-constant, like Date()+1 8:30:00 AM?

TIA,
Harry
 
worked perfectly. thank you.

Klatuu said:
SELECT DateDiff("n",Date + TimeSerial(8,30,0), [DateField) AS MinutesPassed
--
Dave Hargis, Microsoft Access MVP


Harry F. said:
Hello,

I'm sure I'm missing something super easy. How does one calculate the
number of minutes between a field in a Query "ActualDateTime", and a
semi-constant, like Date()+1 8:30:00 AM?

TIA,
Harry
Click to expand...
Click to expand...
 
Back
Top