Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Most recent Date in a query
I am running a salary report, and I'm trying to get the most recent date prior to 2/27/2012. Here is my record Selection {PRRATEHIST.BEG_DATE} in DateTime (2008, 01, 01, 00, 00, 00) to DateTime (2012, 02, 27, 00, 00, 00) and {EMPLOYEE.EMP_STATUS} in ["C", "FR", "PR", "SI", "SU"] and not...- Bronnad
- Thread
- Replies: 0
- Forum: Business Objects: Crystal Reports 4 Other topics
-
Lawson History Table help
I am running a report that pulls from a history table. I have 2 fields... 1- salary on 2/27/2012 (date of merit increase) if {Salary History.BEG_DATE} = #2/27/2012# then if{Salary History.SALARY_CLASS}="Hourly" then{Salary History.PAY_RATE}*{Salary History.ANNUAL_HOURS} else{Salary...- Bronnad
- Thread
- Replies: 20
- Forum: Business Objects: Crystal Reports 4 Other topics
-
Multi if statement in 1 formula
Here is the formula I was trying to run... if {data.DESCRIPTION} = ("Regular", "Bereavement", "Paid Bank", "Jury Duty", "Military - Hours", "Temp Disability/Sick", "Temp Dis-State tax exempt", "Temp Dis - Hours", "Temp Dis-State taxable", "FMLA- FLA", "Military Wages to offset reg", "Bank -...- Bronnad
- Thread
- Replies: 2
- Forum: Business Objects: Crystal Reports 4 Other topics
