System Time

Yahoo Archive
1
In Crystal you can use Time(86400 / seconds past midnight) and format the output as regular HH:MM:SS.

In RB I have always brut forced it with division for hours and then dividing the remainder for minutes, etc...

-Todd C.

-----Original Message-----
From: Jasper Recto [mailto:jrecto@...]
Sent: Thursday, July 21, 2005 7:59 AM
To: Vantage Groups (E-mail)
Subject: [Vantage] System Time


Does anybody know how I can show the system time (which is in seconds from midnight), into an actually time in a report?

Thanks,

Jasper



[Non-text portions of this message have been removed]



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



* Visit your group " vantage <http://groups.yahoo.com/group/vantage> " on the web.


* 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]
2
Does anybody know how to read the systime on the parttran tables? What does that number represent? How do you figure out what time the transaction happened

Thanks,

Jasper





[Non-text portions of this message have been removed]
3
seconds since midnight

-----Original Message-----
From: Jasper Recto [mailto:jrecto@...]
Sent: Monday, February 28, 2005 10:52 AM
To: Vantage Groups (E-mail)
Subject: [Vantage] System Time



Does anybody know how to read the systime on the parttran tables? What does that number represent? How do you figure out what time the transaction happened

Thanks,

Jasper





[Non-text portions of this message have been removed]



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
4
Can anybody tell me, is there a system time( in what table) for when order
have been entered. I would like to write a report that tell me, order number
and the time it was entered into the system



Rich



[Non-text portions of this message have been removed]
5
There is the Order Date in the orderhed table - but that is
user-maintainable so even though the system defaults it to the date it was
set-up, anybody can change it.

If you have the bookings turned on - in the bookdtl table there is a system
date, time and user

And if you have change logs turned on it captures it there also - albeit in
the text so that will be more difficult to extract.


-----Original Message-----
From: Richard Liedke [mailto:rliedke@...]
Sent: April 14, 2005 8:31 AM
To: vantage@yahoogroups.com
Subject: [Vantage] System Time


Can anybody tell me, is there a system time( in what table) for when order
have been entered. I would like to write a report that tell me, order number
and the time it was entered into the system



Rich



[Non-text portions of this message have been removed]



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
6
Thank you very much

-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Thursday, April 14, 2005 8:39 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] System Time


There is the Order Date in the orderhed table - but that is
user-maintainable so even though the system defaults it to the date it was
set-up, anybody can change it.

If you have the bookings turned on - in the bookdtl table there is a system
date, time and user

And if you have change logs turned on it captures it there also - albeit in
the text so that will be more difficult to extract.


-----Original Message-----
From: Richard Liedke [mailto:rliedke@...]
Sent: April 14, 2005 8:31 AM
To: vantage@yahoogroups.com
Subject: [Vantage] System Time


Can anybody tell me, is there a system time( in what table) for when order
have been entered. I would like to write a report that tell me, order number
and the time it was entered into the system



Rich



[Non-text portions of this message have been removed]



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








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
7
Does anybody know how I can show the system time (which is in seconds from midnight), into an actually time in a report?

Thanks,

Jasper



[Non-text portions of this message have been removed]