By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,287 Members | 1,581 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,287 IT Pros & Developers. It's quick & easy.

Date of Birth

P: 1
How I can write this excel calculation in access 2010

=SUM(TODAY ()-G130)/365.25

=SUM(TODAY ()-G130)/365.25

G130 = [Date of Birth]

SUM(TODAY I believe is my problem
Mar 24 '15 #1
Share this Question
Share on Google+
1 Reply

Seth Schrock
Expert 2.5K+
P: 2,951
Well, you aren't summing anything, so you don't need the sum function even in Excel. In Access, you would use the DateDiff() function along with the Date() function (which returns today's date) to get the difference between today and the date specified. The rest of the formula would be the same.

See DateDiff Function for more information.
Mar 24 '15 #2

Post your reply

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