Need to fill calculated date into a field

[terbolee]

I have two fields: [NoDays] & [InvDate]. An integer, such as 14 for [NoDays] and dd/mm/yyyy for [InvDate]. A third date field, also dd/mm/yyyy for [EndDate] needs to be filled in with [InvDate] plus the [NoDays].

I tried After update Event:

Me.EndDate = Me.InvDate + Me.NoDays

It does not work. Can you steer me in the right direction? Thankx.

 

[MStef]

Use DateAdd function.

 

[namliam]

Me.EndDate = Me.InvDate + Me.NoDays

If this doesnt work your InvDate is a TEXT field instead of a Date field.
Change that and it works.
Or you have to do some smart tricks to confert the textstring into a date.

Then again the "good" advice would be:
One should not store calculated values in a table.... Nomalization rule #1 I think.