467,075 Members | 1,067 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,075 developers. It's quick & easy.

Access formula question...

I want to create a query formula in Access.
I have 2 columns that have dates eg: 02/03/06 - from those 2 columns I want access to add the 2 dates and give me a number. I am stuck on what criteria I use to give me the result.
Can someone help me please....

Thanks in advance...
Mar 24 '07 #1
  • viewed: 1535
Share:
6 Replies
ADezii
Expert 8TB
I want to create a query formula in Access.
I have 2 columns that have dates eg: 02/03/06 - from those 2 columns I want access to add the 2 dates and give me a number. I am stuck on what criteria I use to give me the result.
Can someone help me please....

Thanks in advance...
What exactly do you mean "add the 2 dates"?
Mar 24 '07 #2
missinglinq
Expert 2GB
I'd like to know this, too! Came across a question elsewhere last month where someone wanted to "add two times together"; not a time and minutes or hours, but two times!
Mar 24 '07 #3
Sorry what I mean is:

I want to calculate the two dates together example:

02/03/03 05/03/03 the days between is 3.

I want to know the formula to do that.

Hope that makes it clearer.
Mar 24 '07 #4
missinglinq
Expert 2GB
Hey, Stormy! If the difference between 02/03/03 and 05/03/03 is 3 days, you must be on the other side of The Pond! In the USA the difference would be 89 days! Neverless, since you want the difference between two dates, you need to use...yep! The DateDiff Function!

DifferenceInDays = DateDiff("d", YourFirstdate, YourSecondDate)

The "d" makes the answer come up in days. To find out how to get the difference in other units, such as weeks or months, in the code window, place your cursor within "DateDiff" and press <F1>

Good Luck!

Linq
Mar 24 '07 #5
Yeah sorry I forgot about that. I am in New Zealand and we don't have the dates the same as the USA.
Thanks for the help!
Appreciate it.
Mar 24 '07 #6
missinglinq
Expert 2GB
That's why we're here!
Mar 25 '07 #7

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

5 posts views Thread by jillandgordon | last post: by
11 posts views Thread by Brian VanPelt | last post: by
4 posts views Thread by David_from_Chicago | last post: by
reply views Thread by toton.basak@gmail.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.