Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
|
Callback
Support |
If you live in USA, UK, Canada, Australia or New
Zealand, you can leave us details on your question and request us to call you back and discuss
them with you personally (charges apply). |
Click Here
|
Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
|
sp_report date parameters |
Author |
Message |
Vern |
|
Group | : Members |
Posts | : 5 |
Joined | : 2007-10-10 |
|
Profile |
|
Posted : 2009-02-17 09:15:55 |
I am succesfully running a Job Estimates Vs Actuals Summary report using the 'date from' and 'date to' parameters. the date from and date to pull from 2 cells in excel. I would like to be able to run the same report but exactly one year earlier on a different worksheet. When I try to use a formula in excel to get the previous year value, i get a QODBC conversion error.
Also, is there any way to get the same results without using sp_report?
Thanks |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2009-02-17 10:19:17 |
See: SQL for sp_reports Job Estimates vs Actuals Summary / Time by Job Summary
All the predefined DateMacro options available to you are: |All|Today|ThisWeek|ThisWeekToDate|ThisMonth|ThisMonthToDate|ThisQuarter|ThisQuarterToDate |ThisYear|ThisYearToDate|Yesterday|LastWeek|LastWeekToDate|LastMonth|LastMonthToDate|LastQuarter |LastQuarterToDate|LastYear|LastYearToDate|NextWeek|NextFourWeeks|NextMonth|NextQuarter|NextYear|
or you may use:
DateFrom = {d'yyyy-mm-dd'}, DateTo = {d'yyyy-mm-dd'}
instead. |
|
|
|
Vern |
|
Group | : Members |
Posts | : 5 |
Joined | : 2007-10-10 |
|
Profile |
|
Posted : 2009-02-18 03:10:00 |
Tom,
Is there a way to get the same data from a query? That way I can sort the data based on entry dates. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2009-02-18 10:00:10 |
|
|
|
|