substr function error

[S4E]

I receive an error message when I attempt to create a new variable. The variable I am using in the substring function is designated as "long text" within the universe. The value for this variable is a converted date/timestamp formatted as dd/mm/yyyy hh:mm:ss. All I am trying to do is strip away the date while leaving the time portion.

Could someone possibly shed some light as to what this beginner Business Objects user is doing incorrectly?

Thanks,

S4E

 

[blom0344]

Check in data manager how BO designates the type. Even if the universe setting is long text, it may be parsed as a date. In that case you can use :

=FormatDate(<Date Received LONG TEXT> ,"hh:mm:ss")

Ties Blom
Information analyst

 

[S4E]

Thanks,

I used the FormatDate(), and was able to achieve the desired results.