Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Possible to trim "CurrentTime()" string

Hi.

First post, and im quite new to Business Objects, Web Intelligence.

I searched the forum and found no answer to this question:

Is it possible to trim or rightpad a build-in string?

The current TIME format in my company's universe is: HH:MM:SS and I would like to only show HH:MM

So how can I in a string trim the last 3 characters ":SS" using this string:

CurrentTime()

Former Member
Former Member replied

I use CurrentDate() with FormatDate() to get the same result. You could use:

=FormatDate(CurrentDate(); "h:mm")

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question