Need help with code to update a Date field please

[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.

[ADezii]

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.

The only reason I can think of, assuming both Fields are populated, is that
[InvDate] and [EndDate], or either one, are defined as Text and not Date/Time in the underlying Table.

[NeoPa]

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.

Try designing a query based on the underlying table which includes a field ([InvDate] + 14) and see what it returns.