How to sum up a date field in BAQ in Vantage 8.0

Yahoo Archive
1
If I am not mistaken is should be something like this...

ShipHed.ShipDate + Part.LotShelfLife COLUMN-LABEL "ExpiryDate"

This will handle everything that ships as a Part Number.
You may have to add logic to handle the non part numbers...
Good luck,
Aaron Hoyt
Vantage Plastics



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of joeynsknew
Sent: Wednesday, September 14, 2005 9:57 AM
To: vantage@yahoogroups.com
Subject: [Vantage] How to sum up a date field in BAQ in Vantage 8.0.


Dear all,

I'm trying to create a calculation field by using BAQ in Vantage 8.0.

I want to sum up a date field with a numeric field and expect to return
a result in date format.

For example, I'd like to create a calculated Date (say "ExpiryDate") by
adding "Part.LotShelfLife"(Numeric) to "ShipHed.ShipDate"(Date) after
linking up all the related tables; however syntax error is returned.
Can anyone give me some advice?

Thanks a lot.
Gina






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
2
Dear all,

I'm trying to create a calculation field by using BAQ in Vantage 8.0.

I want to sum up a date field with a numeric field and expect to return
a result in date format.

For example, I'd like to create a calculated Date (say "ExpiryDate") by
adding "Part.LotShelfLife"(Numeric) to "ShipHed.ShipDate"(Date) after
linking up all the related tables; however syntax error is returned.
Can anyone give me some advice?

Thanks a lot.
Gina