Can we use the datediff function and put the answer in a cell?

  • Thread starter Thread starter timmone
  • Start date Start date
T

timmone

what we want to do is return the difference of this function into a cell in a
table, can we do it?
 
On Sat, 12 Dec 2009 11:34:01 -0800, timmone

Yes, but you shouldn't. Because that would violate an important
relational database design principle that says "no calculated fields
in the database". Rather you would calculate the value on the fly in a
query:
select DateDiff("d", myStartDate, myEndDate) as DaysBetween
from myTable

-Tom.
Microsoft Access MVP
 
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

Rpt totals of datediff field only if checkbox of another field che 1
DateDiff problem 3
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
DateDiff 4
Using the DateDiff function based on 5 days 12
Convert zero-length string or blank cell to null 3
For Ken Sheridan re rounding DateDiff 16
reffering another cell value which contains RAND() 0

Back
Top