|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss reports for SalesLogix including Crystal, SQL Reports, etc. View the code of conduct for posting guidelines.
|
|
|
|
current date period
Posted: 09 Feb 09 7:02 PM
|
Hi,
I am trying to create a report, where it shows all opportunities due within the current month.
The only options i see close to that is next 30days, but i would like current.
How do i go about doing this?
thanks in advance. |
|
|
|
Re: current date period
Posted: 10 Feb 09 4:25 PM
|
Presuming you are talking about Crystal Reports:
MONTH({OPPORTUNITY.ESTIMATEDCLOSE}) = MONTH(currentdate) and YEAR(({OPPORTUNITY.ESTIMATEDCLOSE}) = YEAR(CURRENTDATE)
Presuming you are talking about a SLX group:
Add 2 conditions with estimatedclose with "Use value as a literal" selected.
< DATEADD(mm, DATEDIFF(mm,0,getdate())+1, 0)
>= DATEADD(mm, DATEDIFF(mm,0,getdate()), 0)
|
|
|
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|