Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
@Christian Berg and @Ambient both great points! I went ahead and referenced the source data and did some spot checking to make sure the dates lined up. As it turns out the dates I converted using the following formula was off by two days! TIMESTAMPADD(SQL_TSI_DAY, "LAST_UPDATE_DATE", TIMESTAMP '1900-01-01 00:00:00') To…
-
@Luis E. Rivas -Oracle Your blogs are fantastic! Part two of your blog is more applicable to this specific dataset, but I couldn't get a date/time format to work using the included Date Converter. I do have a sample dataset I can send you - message me to let me know what's the best way to give it to you.
-
@Gianni Ceresa You are the man! Thank you for helping me figure this out, I posted your response as the best answer. I will definitely be looking into a bug report. Thanks again!
-
@Gianni Ceresa Thank you for your consistent support. I tried re-writing your above formula as a new column (as opposed to a transformation) and received the same null results: Let me know if there is anything else you think I can try. I feel if we can find the answer to this it will be very helpful to future analysts…
-
@Gianni Ceresa I see, so it appears there is no visual conversion I can do for the date, at least here in the data editor, and specifically for .csv file types. I rewrote that formula and this time received no error! However, it then made every value in my date column null: Going back to my point about the dates showing as…
-
@Gianni Ceresa Thank you for your response! Great point about how data is stored in a Csv. I think ultimately what I'm looking for is the OAC equivalent of that visual change to display the stored number as a date. This data will be used to provide visuals aggregated by date, so I am concerned about these visuals showing…