Date Issue

[Chris Bellingha]

I have a field in one of my tables called "Response Date". I wish to create a new field, in the same table, which returns the number of days between the date I enter in "Response Date" and 30/03/07.

I imagine I need to write an AfterUpdate event on Response Date but I can't seem to get the code right.

Can anyone help?

Thanks

Chris

 

[ColinEssex]

Search for DateDiff()

there's no need to post the same question 3 times

Col

 

[Chris Bellingha]

I didnt post the thread 3 times deliberately - my computer hung after pressing the post thread button. If an admin could delete the other two threads I'd appreciate it!

 

[ColinEssex]

are you wanting to count total days? or only working days minus public holidays

Col

 

[Chris Bellingha]

Total days

 

[ColinEssex]

ok, DateDiff() will do it. Its also in Access help with examples

Col

 

[boblarson]

Two things:

1. You shouldn't store a calculated value anyway - just present it via a query.

2. You can delete your own duplicate posts by going into it, clicking on the Edit button and then selecting Delete (and then selecting the delete confirmation).