BAQ Calc time field from serial number

Yahoo Archive
1
The problem may be due to version differences since we are on 8.03.409C. It would have been helpful if I'd mentioned that before.

Ed
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of brenda mohr
Sent: Wednesday, February 06, 2013 8:33 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAQ Calc time field from serial number



I have my Calculated field editor set up as follows:

Field Name: myTime

Data Type: Character

Format: x(8)

Label: myTime

Description is blank

Editor: String(RMAHead.ChangeTime, "HH:MM:SS")

FYI, I am E9.05.607B

Brenda

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf
Of Ed Garbowski
Sent: Wednesday, February 06, 2013 9:04 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] BAQ Calc time field from serial number

Hi Brenda,
When I tried that it displays an error message 'There is a syntax error
with Calculated Field...'. The data type is set to Character and the
format is blank. Is that correct?

Thanks,
Ed
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> ] On
Behalf Of brenda mohr
Sent: Wednesday, February 06, 2013 5:27 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] BAQ Calc time field from serial number

String(RcvDtl.InspectionTime, "HH:MM:SS")

Brenda

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of ed.garbowski@...<mailto:ed.garbowski%40sbcglobal.net>
Sent: Tuesday, February 05, 2013 11:00 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] BAQ Calc time field from serial number

I am trying to display the InspectionTime from the RcvDtl table in a
BAQ, but could use some help in how to display it correctly. The time is
stored as the number of seconds since midnight, so dividing it by 3600
gives the correct hour, but the remainder is not the actual minutes, but
rather the percent of the hour remaining.
Is there a simple way to create the calculated field to display the
correct HH:MM based on the time serial number?
Ed

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

________________________________

The information contained in this message is intended solely for the
individual to whom it is specifically and originally addressed. This
message and its contents may contain confidential or privileged
information. If you are not the intended recipient, you are hereby
notified that any disclosure or distribution, or taking any action in
reliance on the contents of this information, is strictly prohibited.
We have taken precautions to minimize the risk of transmitting software
viruses, but we advise you to carry out your own virus checks on any
attachment to this message. We cannot accept liability for any loss or
damage caused by software viruses.

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

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



[Non-text portions of this message have been removed]
2
I am trying to display the InspectionTime from the RcvDtl table in a BAQ, but could use some help in how to display it correctly. The time is stored as the number of seconds since midnight, so dividing it by 3600 gives the correct hour, but the remainder is not the actual minutes, but rather the percent of the hour remaining.
Is there a simple way to create the calculated field to display the correct HH:MM based on the time serial number?
Ed
3
String(RcvDtl.InspectionTime, "HH:MM:SS")



Brenda



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of ed.garbowski@...
Sent: Tuesday, February 05, 2013 11:00 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ Calc time field from serial number





I am trying to display the InspectionTime from the RcvDtl table in a
BAQ, but could use some help in how to display it correctly. The time is
stored as the number of seconds since midnight, so dividing it by 3600
gives the correct hour, but the remainder is not the actual minutes, but
rather the percent of the hour remaining.
Is there a simple way to create the calculated field to display the
correct HH:MM based on the time serial number?
Ed





[Non-text portions of this message have been removed]
4
Hi Brenda,
When I tried that it displays an error message 'There is a syntax error with Calculated Field...'. The data type is set to Character and the format is blank. Is that correct?

Thanks,
Ed
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of brenda mohr
Sent: Wednesday, February 06, 2013 5:27 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAQ Calc time field from serial number



String(RcvDtl.InspectionTime, "HH:MM:SS")

Brenda

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf
Of ed.garbowski@...<mailto:ed.garbowski%40sbcglobal.net>
Sent: Tuesday, February 05, 2013 11:00 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] BAQ Calc time field from serial number

I am trying to display the InspectionTime from the RcvDtl table in a
BAQ, but could use some help in how to display it correctly. The time is
stored as the number of seconds since midnight, so dividing it by 3600
gives the correct hour, but the remainder is not the actual minutes, but
rather the percent of the hour remaining.
Is there a simple way to create the calculated field to display the
correct HH:MM based on the time serial number?
Ed

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


________________________________

The information contained in this message is intended solely for the individual to whom it is specifically and originally addressed. This message and its contents may contain confidential or privileged information. If you are not the intended recipient, you are hereby notified that any disclosure or distribution, or taking any action in reliance on the contents of this information, is strictly prohibited.
We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses.


[Non-text portions of this message have been removed]
5
I have my Calculated field editor set up as follows:



Field Name: myTime

Data Type: Character

Format: x(8)

Label: myTime

Description is blank

Editor: String(RMAHead.ChangeTime, "HH:MM:SS")



FYI, I am E9.05.607B



Brenda



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ed Garbowski
Sent: Wednesday, February 06, 2013 9:04 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAQ Calc time field from serial number





Hi Brenda,
When I tried that it displays an error message 'There is a syntax error
with Calculated Field...'. The data type is set to Character and the
format is blank. Is that correct?

Thanks,
Ed
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of brenda mohr
Sent: Wednesday, February 06, 2013 5:27 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] BAQ Calc time field from serial number

String(RcvDtl.InspectionTime, "HH:MM:SS")

Brenda

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of ed.garbowski@... <mailto:ed.garbowski%40sbcglobal.net>
Sent: Tuesday, February 05, 2013 11:00 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] BAQ Calc time field from serial number

I am trying to display the InspectionTime from the RcvDtl table in a
BAQ, but could use some help in how to display it correctly. The time is
stored as the number of seconds since midnight, so dividing it by 3600
gives the correct hour, but the remainder is not the actual minutes, but
rather the percent of the hour remaining.
Is there a simple way to create the calculated field to display the
correct HH:MM based on the time serial number?
Ed

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

________________________________

The information contained in this message is intended solely for the
individual to whom it is specifically and originally addressed. This
message and its contents may contain confidential or privileged
information. If you are not the intended recipient, you are hereby
notified that any disclosure or distribution, or taking any action in
reliance on the contents of this information, is strictly prohibited.
We have taken precautions to minimize the risk of transmitting software
viruses, but we advise you to carry out your own virus checks on any
attachment to this message. We cannot accept liability for any loss or
damage caused by software viruses.

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





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