I need help!!!
I've spent lord knows how long trying to sort out this little problem i'm having with dates in oracle/crystal and if i don't ask for help now i'm going to go insane..
i've written a report to show the last date every employee worked a particular type of shift... but i need a separate/similar report to show the records where the last date was over 6 months ago, and another one (or section within) that shows the results for between 5-6 months ago... where the user inputs what group they want to see the results for...
if you want to see the current code i've got then shout...
otherwise i've tried: "(lastworkeddate") >= {current_date-180}" - but in SQLPlus i'm getting an error saying i've got an invalid relational operator..
arggh!!!
thanks in advance..
Kathryn
- Visitors can check out the Forum FAQ by clicking this link. You have to register before you can post: click the REGISTER link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View our Forum Privacy Policy.
- Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!
Reply to: Bluddy crystal reports/oracle/sql!!
Collapse
You are not logged in or you do not have permission to access this page. This could be due to one of several reasons:
- You are not logged in. If you are already registered, fill in the form below to log in, or follow the "Sign Up" link to register a new account.
- You may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
- If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.
Logging in...
Previously on "Bluddy crystal reports/oracle/sql!!"
Collapse
- Home
- News & Features
- First Timers
- IR35 / S660 / BN66
- Employee Benefit Trusts
- Agency Workers Regulations
- MSC Legislation
- Limited Companies
- Dividends
- Umbrella Company
- VAT / Flat Rate VAT
- Job News & Guides
- Money News & Guides
- Guide to Contracts
- Successful Contracting
- Contracting Overseas
- Contractor Calculators
- MVL
- Contractor Expenses
Advertisers
Contractor Services
CUK News
- Hiring of IT contractors returned to growth in May 2026, following 33 months ‘in the red’ Today 06:02
- Zero Hours Contract Reform: A key consultation for recruiters, employers and contractors is finally here Jun 12 04:43
- Bills of Exchange: Here’s what caught my attention as an umbrella compliance expert Jun 11 03:46
- Loan charge recall issue returns, with new demands making UK contractors ‘half-suicidal’ Jun 10 03:58
- AI interviews are here. Here's how IT contractors can ace them Jun 9 06:53
- Closing your limited company isn't failure. It's just the end of a chapter. Jun 8 05:00
- Young people not in education, employment or training isn’t a contractor’s problem. It’s a problem for us all Jun 5 05:26
- How does HMRC’s forward interest change benefit contractors? Jun 4 04:22
- What are Bills of Exchange, and should HMRC's alert worry umbrella contractors? Jun 3 04:09
- Bills of Exchange fail to avoid new umbrella company rules, says HMRC Jun 2 05:32
