I’m using XIR2 webi, and I don’t have the option to make any changes in the universe.
I have a field which is text and contains a time in 24hour format “13:15:21”.
How do I change the time field to an actual time (or date) since it’s in 24 hour format? If it were 12, I guess I could use ToDate([TimeField];“hh:mm:ss”)
How about the second part of my question? I’m aware of the =RelativeDate() function, but don’t know how to use for hours. I suppose I could use a fraction (decimal) of a day, but that would not keep the hours/mins/secs accurate.