Report Builder and Time display

Wild guess but....in the Job Module setup under company configuration what is the "Time Format" set to? Hours/Minutes or Hours/Hundredths? If hundredths the decimal may be causing the formatting to choke. Easy thing to try would be changing "HH:MM" to "99.99" and see if something displays.
-Todd C.

-----Original Message-----
From: Mike Lowe [mailto:MLowe@...]
Sent: Friday, June 24, 2005 2:30 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Report Builder and Time display


I'm trying to display the time on a Report Builder report in HH:MM format. I've created a calculated field with the following expression using the LaborHed table

STRING(ActualClockInTime,"HH:MM")

but 00:00 is displaying.

What have I missed here?

Mike Lowe
Corporate Information Systems Manager
Connor Manufacturing Services
MLowe@...
Ofc: 949-713-3328
Cell: 949-973-7621
Fax: 949-666-5268



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links



_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
I'm trying to display the time on a Report Builder report in HH:MM format. I've created a calculated field with the following expression using the LaborHed table

STRING(ActualClockInTime,"HH:MM")

but 00:00 is displaying.

What have I missed here?

Mike Lowe
Corporate Information Systems Manager
Connor Manufacturing Services
MLowe@...
Ofc: 949-713-3328
Cell: 949-973-7621
Fax: 949-666-5268