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
 
SELECT DateDiff("n",Date + TimeSerial(8,30,0), [DateField) AS MinutesPassed
 
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...
 
You must log in or register to reply here.

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

Datediff semi-annual periods 1
Access DateDiff function 0
Changing constants in a query to user input values 2
DateDiff Conversion 7
Datediff 2
DateDiff Null Values 2
Sum and DateDiff 2
dateDiff help 2

Back
Top