G
Guest
How can I format DateDiff to display the age in years and months? I use a dob
(date of birth) and a Today field. DateDiff would be used in a query.
(date of birth) and a Today field. DateDiff would be used in a query.
RMCDD997 said:How can I format DateDiff to display the age in years and months? I use a dob
(date of birth) and a Today field. DateDiff would be used in a query.
How can I format DateDiff to display the age in years and months? I use a dob
(date of birth) and a Today field. DateDiff would be used in a query.
RMCDD997 said:Thanks for you reply fredg. In a form, I have a "DOB", "Today" & an "Age"
text box. I copied & debugged the Date2Diffs module. "Age" is unbound
using
the control source of: "=Diff2Dates("ymd",[dob],[today],True)" (minus
quotes). When I change to form view, I receive the error #Name? in the
"Age"
text box. Any ideas? Thanks
fredg said:You can't using just DateDiff.
You can if you use this function:
Check "A More Complete DateDiff Function" at
http://www.accessmvp.com/djsteele/Diff2Dates.html
Thanks for you reply fredg. In a form, I have a "DOB", "Today" & an "Age"
text box. I copied & debugged the Date2Diffs module. "Age" is unbound using
the control source of: "=Diff2Dates("ymd",[dob],[today],True)" (minus
quotes). When I change to form view, I receive the error #Name? in the "Age"
text box. Any ideas? Thanks
fredg said:You can't using just DateDiff.
You can if you use this function:
Check "A More Complete DateDiff Function" at
http://www.accessmvp.com/djsteele/Diff2Dates.html
I have a 40-second delay in printing from Vista; as well, the screen freezes
until the Canon laser printer starts. This is despite the firewall between
Vista and the printer being off. Canon support can't help.
Anyone out there with a remedy to allow me to keep writing while the printer
is preparing to print?
Thanks.
fredg said:Thanks for you reply fredg. In a form, I have a "DOB", "Today" & an "Age"
text box. I copied & debugged the Date2Diffs module. "Age" is unbound using
the control source of: "=Diff2Dates("ymd",[dob],[today],True)" (minus
quotes). When I change to form view, I receive the error #Name? in the "Age"
text box. Any ideas? Thanks
fredg said:On Wed, 1 Aug 2007 16:16:00 -0700, RMCDD997 wrote:
How can I format DateDiff to display the age in years and months? I use a dob
(date of birth) and a Today field. DateDiff would be used in a query.
You can't using just DateDiff.
You can if you use this function:
Check "A More Complete DateDiff Function" at
http://www.accessmvp.com/djsteele/Diff2Dates.html
Well, if you are going to use Access, you should use Access defined
functions. Today is an Excel function.
In Access Date() will return the current date.
Now() will return the current date and time.
You have enclosed Today within brackets, so Access is looking for a
field named Today. That will cause the #Name error.
Try:
=Diff2Dates("ymd",[dob],Date(),True)
RMCDD997 said:Thanks for you reply James. Could you read my replay to "fredg"? Thanks.