Create a calculated field and use the following syntax
STRING(TIME( ), "HH:MM:SS")
Mike Lowe
Connor Manufacturing Services
-----Original Message-----
From: progress92000 [mailto:nvong@...]
Sent: Monday, April 04, 2005 10:15 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Vantage time conversion
I want to convert time (28956) in vantage to regular time in Report
builder. Any idea?
Thank you,
Nam
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]
STRING(TIME( ), "HH:MM:SS")
Mike Lowe
Connor Manufacturing Services
-----Original Message-----
From: progress92000 [mailto:nvong@...]
Sent: Monday, April 04, 2005 10:15 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Vantage time conversion
I want to convert time (28956) in vantage to regular time in Report
builder. Any idea?
Thank you,
Nam
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]