Date plus x days = FutureDate

[vivasuzi]

Hi guys,

I thought this would be simple but I can't seem to wrap my mind around it. I want to take a date entered in the db and report on future dates based on that.

Ie: I have database field 'LetterSentDate' that is entered in by the user. The letter has 20 days to arrive at it's destination. I want to print a report that shows 'LetterSentDate' and 'ExpectedArrivalDate'.

ExpectedArrivalDate would be auto-calculated at runtime of the report. So how do I do this? How do I add 20 days to the original date? I'm looking for a simple solution, I already know how to make a report, I just want a formula to calculate the future date! Thanx a lot

*Suzanne*

http://www14.brinkster.com/vivasuzi

 

[vivasuzi]

btw - I want it to add 20 days, this includes weekends. Every day treated the same on this system.

*Suzanne*

http://www14.brinkster.com/vivasuzi

 

[RoyVidar]

If you have the LetterSentDate in the recordsource of the report, add an unbound text control to the report, set the format to the appropriate date format and set it's controlsource to:

[tt]=LetterSentDate+20[/tt]

Roy-Vidar

 

[vivasuzi]

Easier than I thought! I don't know what I was thinking Thanks

*Suzanne*

http://www14.brinkster.com/vivasuzi