currenttime() displayed with GMT+00:00

building reports webintelligence
1

Hi

if I concat currenttime() with another string I get ‘GMT+00:00’ added to the result

=CurrentTime()
gives … 15:45:67

="Hello world: " + CurrentTime()
gives … "Hello world: 15:46:67 GMT+00:00

How do I get just “Hello world: 15:46:67” other than using the replace() function. Is there someway to stop GMT+00:00 being appended if a ‘time’ type is coverted to a string?

Thanks guys

This is Webi BI4.1 SP5

JJ

jane123 :it: (BOB member since 2006-02-22)

2

Workaround:

="Hello World: "+FormatDate(CurrentDate();"HH:mm:ss")

hh=12 hour format, HH=24 hour format.

HTH

NMG

mcnelson :uk: (BOB member since 2008-10-09)

3

Hi

thanks for the reply. Perhaps I was simplifying the issue. Its not CurrentTime but LastExecutionTime I’m interested in.

Just used CurrentTime as it doesn’t have any parameters.

Both return a ‘time’ data type. I’ll try your suggestion though.

JJ

jane123 :it: (BOB member since 2006-02-22)

4

You can apply the same to the lastexecutiondate() function to give you the time without regional information, e.g.:

="Hello World: "+FormatDate(LastExecutionDate();"HH:mm:ss")

HTH

NMG

mcnelson :uk: (BOB member since 2008-10-09)