|
-
Jan 13th, 2004, 02:52 PM
#1
Thread Starter
New Member
Calculating between 2 dates
Hi everyone,
i'm working with msaccess forms.
I have 2 dates: date1 - date2
For example, date1= #01/01/2003# and date2= #03/01/2004#
I used dateresult= -datediff("y",[date2],[date1]) and it's just gives me dateresult = 1
I want to get as a result the number of years, the number of months and number of days.
Please I need your help.
Sorry for my bad english!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|