BusinessObjects Board

Time format 24 HH

building reports webintelligence
#1

Hi Expert ,

I am using BI 4.2 opRep and need formula to create Time format with 24 hours.

=ToDate(
If(Length(FormatNumber([FIELD];“0”))=6;FormatNumber([FIELD];“0”);“0”+FormatNumber([FIELD];“0”))
;“HHmmss”)

Result is showing with “2:43:10 PM”
I need time format with 24 hr 14:43:10

Please advice, to convert Time in 24 hr format.
Thankyou in advance for your support.

BR
Sultan Khan

#2

formatdate(… ; “HH:mm:ss”)

#3

Thank you for your support.
Right now getting error “Missing quotation mark after ‘HH:mm:ss”)’ at position 21. (IES 10016)”

Please guide

BR
Sultan

#4

Make sure you have " (double quote) before and after the time format, not a single quote. “HH:mm:ss” not 'HH:mm:ss"

FormatDate( [DateTimeField] ; “HH:mm:ss” )

1 Like