3013484 — Oracle Analytics

Welcome to the Oracle Analytics Community

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

3013484 Rank 2 - Community Beginner

Comments

  • where ( T173203.SRVC_ACCT_ID = T173903.GAS_SRVC_ACCT_ID and T173508.CALENDAR_DATE = TO_DATE('2015-08-31' , 'YYYY-MM-DD') and 90 < T173903.EXDT_STDT_DATE_DIFF - ( TRUNC( TO_DATE('2015-08-31' , 'YYYY-MM-DD') ) - TRUNC( TO_DATE('2015-08-31' , 'YYYY-MM-DD') ) ) and T173508.CALENDAR_DATE >= T173903.GAS_SA_STRT_DT and…
  • hello Thomas, I will do that on Monday and let you know. Thanks for replying.