90 Days Report

[ebisabes]

I want a report that gives me a list of employees whos hire date + 90 days is within the current month. I know how to do this by derived field "HIRE DATE + 90 days" & then 2 report variables asking me for the dates I want my derived field to fall between. But I am wondering if I can do it without any prompts since the system knows what the date is, can I do something like:

(REPORTS.V_EMPLOYEE.HIREDATE + 90 days) BETWEEN @MONTHBEG( @NOW ) AND @MONTHEND( @NOW )

I added the '@MONTHEND ( @NOW )... it wasn't in there... why is MONTHBEG there but not Month End???

(when I enter the above scenario, it returns "Missing Right Parenthesis")

 

[CharlesCook]

I don't have access to this brand of database right now so I can't sort out the syntax for you. But the way I have come up with monthend in the past is:

(@MONTHBEG(@NOW + 1 Month) - 1 Day)

CharlesCook.com
ADP - PeopleSoft - SAP
ReportSmith - Crystal Reports - SQR - Query - Access
Reporting - Interfaces - Data Mining