For some reason solving other people's problems (when answers occur to me) is more fun than tackling the seemingly-insoluble ones I have. :-)
Its sort of like cleaning someone else's house -- much more fun than mucking about with my old stuff.
--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
    bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of jplehr
Sent: Friday, April 23, 2010 2:48 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Direction to compare dates
Brian,
Thanks for the quick response on this. I think sometimes I try to get to creative and forget the easier ones. This works well and should give me what we need. Thanks again.
Jeff
Its sort of like cleaning someone else's house -- much more fun than mucking about with my old stuff.
--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
    bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of jplehr
Sent: Friday, April 23, 2010 2:48 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Direction to compare dates
Brian,
Thanks for the quick response on this. I think sometimes I try to get to creative and forget the easier ones. This works well and should give me what we need. Thanks again.
Jeff
--- In vantage@yahoogroups.com, "Brian W. Spolarich " <bspolarich@...> wrote:
>
> You'll probably need to use a calculated field in your BAQ to do the date arithmetic.
>
> I did a calculated field whose expression was:
>
> OrderRel.NeedByDate - OrderHed.OrderDate
>
> And set the datatype to integer
>
> It returns the number of days between them. You can then filter in the dashboard for those that are < 35.
>
> -brian
>
> --
> Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
> Â Â Â Â bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of jplehr
> Sent: Thursday, April 22, 2010 3:01 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Direction to compare dates
>
> Vantage 8.03.408A
>
> I am looking for some guidence. Might need some good detail rather then a general approach. This might be a little beyond my skills.
>
> I want to compare the orderhed.orderdate to the orderrel.needbydate. I only want to pull those that differ less then 5 weeks.
>
> I was going to start off with a BAQ/Dashboard. Long term would probably want an email from a BPM. Don't really care which way at this point. Just not sure what I need to do to make the comparison.
>
> Ideas are greatly appreciated.
>
> Jeff
>
>
>
> ------------------------------------
>
> 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/linksYahoo! 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/linksYahoo! Groups Links