Dynamic dates (Prior week Saturday-Friday)

Yahoo Archive
1
Boyd,



As far as I know, these dynamics dates cannot be modified in the system.



What I would suggest doing is use the dynamic dates to select "too much
data" and then do the final dynamic filtering in Crystal.



For example, for Begin Date choose "First of month - 1 mo" and End Date =
"Today"



Obviously this has too much data in its scope but now utilize Crystal to
dynamically filter that dataset using formulas. You will have to create
another version of the Crystal report you're running and just modify it
using the Record Select Expert and use your dynamic filtering in a couple
formulas.





Vic



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
boyd_timco
Sent: Friday, October 12, 2012 11:07 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Dynamic dates (Prior week Saturday-Friday)





I am trying to automate running a report by using dynamic dates on the
report options set to the prior Saturday through Friday (our payroll week).
The report needs to run Tuesday after all edits have been completed.
I see options for Last Saturday and Last Friday but when running on Tuesday
the Last Saturday would actually come after the Last Friday.

Can additional dynamic dates be added?

Any ideas on how to accomplish in Vantage 8?

Thanks
Boyd Creasy
TIMCO Aerosystems



No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2221 / Virus Database: 2441/5327 - Release Date: 10/12/12




-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2221 / Virus Database: 2441/5327 - Release Date: 10/12/12

[Non-text portions of this message have been removed]
2
I am trying to automate running a report by using dynamic dates on the report options set to the prior Saturday through Friday (our payroll week).
The report needs to run Tuesday after all edits have been completed.
I see options for Last Saturday and Last Friday but when running on Tuesday the Last Saturday would actually come after the Last Friday.

Can additional dynamic dates be added?

Any ideas on how to accomplish in Vantage 8?

Thanks
Boyd Creasy
TIMCO Aerosystems