Skip to Main Content
Forums

Oracle Analytics Cloud

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Reports and Analytics

zelagozumFeb 23 2024

Hello. I'm getting an error in my reports sql condition.

Here's the query i tried

  1. CASE WHEN "Organization0"."ExtnAttributeChar011_Meaning" = 'Tier 3' AND "Organization0"."ExtnAttributeChar019_Meaning" IN ('LCS-Multi-Site', 'LCS-National Acts') then 'NA' else CAST(To_DATETIME("Goals_c"."FacetoFaceMeeting1_c", 'mm/dd/yyyy') AS CHAR) End
  2. CASE WHEN "Organization0"."ExtnAttributeChar011_Meaning" = 'Tier 3' AND "Organization0"."ExtnAttributeChar019_Meaning" IN ('LCS-Multi-Site', 'LCS-National Acts') then 'NA' else CAST(To_DATETIME("Goals_c"."FacetoFaceMeeting1_c", 'MM-DD-YYYY') AS CHAR) End
  3. CASE WHEN "Organization0"."ExtnAttributeChar011_Meaning" = 'Tier 3' AND "Organization0"."ExtnAttributeChar019_Meaning" IN ('LCS-Multi-Site', 'LCS-National Acts') then 'NA' else CAST(To_DATETIME("Goals_c"."FacetoFaceMeeting1_c", 'mm-dd-yyyy') AS CHAR) End
  4. CASE WHEN "Organization0"."ExtnAttributeChar011_Meaning" = 'Tier 3' AND "Organization0"."ExtnAttributeChar019_Meaning" IN ('LCS-Multi-Site', 'LCS-National Acts') then 'NA' else CAST(To_DATE("Goals_c"."FacetoFaceMeeting1_c", 'mm/dd/yyyy') AS CHAR) End --not accepted since funtion to_date is not accepted.

and sill getting the error message below
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked by Renae Stout-Oracle on Jul 8 2024
Added on Feb 23 2024
#analytics, #reports, #salescloud
3 comments
523 views
1 mention