Community
Showing results for 
Search instead for 
Do you mean 
Reply

Add Time to a date in a report

New Member
Posts: 6
Country: USA

Add Time to a date in a report

I want to take a date and add a fixed amount of time to it for a distructions date in a report, how do I do that ?

 

I tried in a custom field [<date> + 7] and that is what was displayed.

 

Thanks

Will

Platinum Elite Contributor
Posts: 6,651
Country: USA

Re: Add Time to a date in a report

That's not a valid Visual Basic statement. What you want is more comples than a simple statement like that ans would require a short VB script program.

 

There is a third party book with comprehensive training information on the ACT! reports, here is the link.

https://www.packtpub.com/sage-act-2011-dashboard-and-report-cookbook/book

 

Full disclusure I wrote the reports chapters of the book.  The report chapters work for all version of the ACT! program since ACT! 2007.

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129