BusinessObjects Board

function CurrentTime()

In webi I’m using the function"CurrentTime()".
The return is full time: 16:12:43 (HH24:MI:SS).

I try to get only 16:12 (HH24:MI).

Is is possible with the currenttime-function to format the output, like:
CurrentTime(HH24:MI)? (error message: WIS 10022)

I can’t find anyware how webi uses ‘format mask’.

When I tried to the description-help in webi “More on this function” (really sure “fx CurrentTime” is selected). The link goes to the description on the function “Count”.

The goal is to get the reports last refresh-time, and I found it as a template, under ‘Free-Standing cells’ / 'Formula and Text Cells" / “Last refresh Date” which gives me exacly what I want. I just try to learn webi-functions.

Henrik


henbar :sweden: (BOB member since 2007-08-06)

Might Help


aniketp :uk: (BOB member since 2007-10-05)