conver number to date

[alkrm]

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]

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

 

[alkrm]

that's fair enough

THANX

 

[alkrm]

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]

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?

 

[alkrm]

solved

thanks all for usefull help

great examples Pat .