Date / Timestamp Issue

Teresa Modesta

Hello,

I have this problem where I have a timestamp in an analysis from a subject area dimension field that I convert to a date to do some date manipulation with.

This worked, but then after saving reloading etc it now errors with a conversion error after no changes at all.

Robert Angel

Hi,

I have seen this also.

The fix is to make sure you explicitly convert it (cast to...) and never rely on implicit conversion at any point.

I am not sure why this works initially, and then fails, but that is the fix.

Gianni Ceresa

Larry's Friday Girl wrote:it now errors with a conversion error 

Hi,

Thanks for letting us know

In case it's a question, what's the question?

And you will have to post a bit more if you expect an answer ...

Things like the detailed error, the conversion used, the version etc.

Martin van Donselaar

We cannot help you unless you answer at least the following questions: What exactly did you try, What Is the exact error, which Obiee version do you use, ..

Teresa Modesta

Sorry, I'm a bad girl...

Your resident angel solved my problem, he was dead right, but I will follow the rules next time...