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

Months and Day Function

P: n/a
Friends I have a form whith three textboxes, A, B, C , D and F. The
first two are used to store a starting and ending date data. The C, D
and F should be a calculated form.

In textbox A I will store a starting date (mm/dd/yyyy) and in the
textbox B I will store the ending date.
This is what I would like to do:

Textbox C returns the number of days between A and B.
Textbox D returns the number of weeks between A and B.
Textbox F returns the number of months between A and B.

Can anyone help me? Thanks.
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Look at the DateDiff function in the help file
Here's the interval arguments for the first part of the function
yyyy Year
q Quarter
m Month
y Day of year
w Weekday
ww Week
h Hour
n Minute
s Second

Jeff

"Paolo" <jp***@tin.it> wrote in message
news:9f**************************@posting.google.c om...
Friends I have a form whith three textboxes, A, B, C , D and F. The
first two are used to store a starting and ending date data. The C, D
and F should be a calculated form.

In textbox A I will store a starting date (mm/dd/yyyy) and in the
textbox B I will store the ending date.
This is what I would like to do:

Textbox C returns the number of days between A and B.
Textbox D returns the number of weeks between A and B.
Textbox F returns the number of months between A and B.

Can anyone help me? Thanks.

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.