Thread: [Solved] Using the Delay fields
View Single Post
 
Old 08-15-2011, 03:49 PM
Foxfire Foxfire is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Jul 2011
Posts: 3
Foxfire is on a distinguished road
Default

Thanks for the replies by the way, I really appreciate the help.

I have an SQL database I'm pulling the date fields from and here is what happens. Unfortunately I can't modify the date in the database at all, so I have to do it all on the letter.

Paid_to_date = 16/08/2011.

Invoice from <delay by 1 day> to <delay by 1 month>

The above merge fields pull through the following information.

Invoice from 17/08/2011 to 16/09/2011.

However without changing anything, if I create the letter from a file with a paid to date anywhere in February, it does the following:

Paid_to_date = 14/02/2011

Invoice from 12/02/2011 to 14/03/2011.

If I set the delay to 3, instead of 1. February then works fine. Maybe I typed something wrong. When I've a chance I'll double check it. But if the above field is correct, my letter should be correct.
Reply With Quote