conver number to date

alkrm · Jan 6, 2004

hi,
i have this main three fields

date of buying "date/time" formated
duration "number" formated
maturity"date/time" formated

doing this formula,
Maturity = [date of buying]+[duration]

where duration is in months
how can i convert the number to date/time format , so i can make the formula works,
now it adding only days ,

NOTE" SOME MONTHS ARE 31 DAYS,30 DAYS , 29 ,28
HOW CAN IT BE CONVERTABLE REGARDING TO THE SYSTEM DATE

I THINK AM LOST ........... ANY DIRECTION ???

Rich · Jan 6, 2004

DateAdd("m",[duration],[date of buying])

alkrm · Jan 6, 2004

that's fair enough

THANX

alkrm · Jan 6, 2004

BUG

i though that solved it but....
THIS WAY IS ONLY ADDING THE MONTHS WITHOUT TAKING CARE OF THE MONTHS WITH 30 DAYS OR 31

any extra directions

thnx in advance

Mile-O · Jan 6, 2004

I fail to see where your problem is. What Rich proposed should suffice as the DateAdd() function does take months into account.

Add 1 month to 31 October and you'll get 30 November.
Add 1 month to 31 January and you'll get 28 February (29 February on a leap year).
Add 1 month to 31 December and you'll get 31 January.

How does this not take the different month lengths into account?

Pat Hartman · Jan 7, 2004

Useful Date Functions

Are you expecting to add 1m to the last day of one month and end up with the last day of the next month? Here's a db with a bunch of date functions. You may find one you can use.

I updated this db to include an AGE calculation and a Business days calculation. I also changed the format to a tabbed form.

alkrm · Jan 11, 2004

solved

thanks all for usefull help

great examples Pat .

Pat Hartman · Feb 3, 2004

conver number to date

alkrm

Registered User.

Rich

Guest

alkrm

Registered User.

alkrm

Registered User.

Mile-O

Back once again...

Pat Hartman

Super Moderator

Attachments

alkrm

Registered User.

Pat Hartman

Super Moderator

Similar threads

Users who are viewing this thread