User_GEPNO — Oracle Analytics

Welcome to the Oracle Analytics Community

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

User_GEPNO Rank 2 - Community Beginner

Comments

  • Thank you Gianni, I need to take this up internally, because I cannot access the physical query. Once I have our internal response, I will let you know! I will leave this question opened for now.
  • Hello Gianni, I tried using this formula, one way or another, I cannot make it work unfortunately, no results everytime. Do you think there is a mistake in the syntax? CAST ("Contact Custom Obj 9"."Date Created" as DATE) = CAST ("Contact"."Contact Created Date/Time" as DATE) Thanks
  • Exactly my point, but how to make sure those are dates - because I have only changed the formatting so it matches, but not the value itself. Is there a workaround or better - how to find out the original value? This is the table when I uncheck "override default formatting" I am quite skilled with data in excel/other BI…
  • Dear Gianni, thank you for your prompt answer. 1) It is an Analysis, as you assumed 2) I thought exactly what you are pointing out at - I should have mentioned it in the original post - but it doesnt work for me, I get "no result" for Filters "Contact Custom Obj 9"."Date Created" = "Contact"."Contact Created Date/Time" But…