View Single Post
 
Old 12-12-2014, 06:18 AM
ballst ballst is offline Windows XP Office 2003
Advanced Beginner
 
Join Date: Dec 2014
Posts: 32
ballst is on a distinguished road
Default

Macropod,

Thanks again for the reply.

I've been trying this one again this morning, but with only limited success.

1. The dates now automatically calculate, so thank you. However as soon as you print, or even preview print all the dates revert to the same day. For example if you take 01/01/2015 as date of issue all the other dates revert to 26/03/2015. The dates will remain as incorrect until you change the Issue date, however again any attempt to print renders it faulty.

2. Re the dates in Point D, for info the target date should be 126 days from the date of issue, so the flexibility of the additional input box is a great solution for those that slip. For reference the first date of availability is always a Monday, so it could perhaps be linked to the first date calculation in D, i.e the date the document is to be returned? If so the first week of availability is always 5 weeks after the document is due.


Ballst
Reply With Quote