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
