Date a year from now after date is updated in another field 1

[JSD]

Hello

I'm trying to add a date column to a table that calculates a new date one year from an updated field in another date column...in need of some of your knowledge.

Many thanks

Jeremy

 

[PoopCheese]

Use the DateAdd Function. Something like this...

NewDateField = DateAdd("y", 1, OldDateField)

Good Luck,
Poop

 

[JSD]

Hello

Thanks poopcheese, that worked perfectly. That one is going into the permanent memory banks...

Jeremy

 

[JSD]

Hello

Me again. Is there a way to make the same date calculation in tables as well? Let me know if you see this...

Thanks

Jeremy

 

[PoopCheese]

Unless you are using SQL server, you'll need to run an update query to update the NextYear field after each new date record is added.

If using SQL server, you can set a trigger on the table to do the same thing.

-Poop