Date Calculation

[zyus]

I have aprdt (date field) and want to add number from arrmth (number field)
to get new date..

For ex

Aprdt arrmth newdate
31/07/09 1 31/08/09
31/07/09 2 30/09/09

How to do it in query....TQ

 

[zyus]

I have aprdt (date field) and want to add number from arrmth (number field)
to get new date..

For ex

Aprdt arrmth newdate
31/07/09 1 31/08/09
31/07/09 2 30/09/09

How to do it in query....TQ

Actually what i really want is the aprdt minus arrmth and the new result
will be

 

[fredg]

Actually what i really want is the aprdt minus arrmth and the new result
will be

i would suggest you look up the DateAdd function in VBA help.

To add the arrmth value to a date in a query:
NewDateateAdd("m",[arrmth],[Aprdt])

To subtract the arrmth value from a date:
NewDateateAdd("m",-[arrmth],[Aprdt])