on 06-21-2011 3:06 PM
Hi Experts,
I am getting parsing failed for the following case statement when i am trying to create a new object. Please kinldy help me out on this issue.
CASE WHEN {fn month(IDENSLABBHDLY.FullDate)}>= 6 and {fn year(IDENSLABBHDLY.FullDate)} = 2011 or {fn year(IDENSLABBHDLY.FullDate)} > 2011 THEN [IDENSLABBHDLY.Dy_Calls]-[IDENSLABBHDLY.Dy_HO_CHAN_ALLOC] ELSE [IDENSLABBHDLY.Dy_Calls] END
Thanks
Thanks it is working fine.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
What type of database is it?
Standard syntax would be:
CASE WHEN {fn month(IDENSLABBHDLY.FullDate)}>= 6 and {fn year(IDENSLABBHDLY.FullDate)} = 2011 or {fn year(IDENSLABBHDLY.FullDate)} > 2011 THEN table.Dy_HO_CHAN_ALLOC ELSE table.Dy_Calls END
Have you tried using your code in a SQL client?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.