Re: Report help
- From: LX-i <lxi0007@xxxxxxxxxxxx>
- Date: Tue, 21 Nov 2006 18:52:35 -0600
jeff@xxxxxxxxxx wrote:
Does anybody have a good routine I can use to calculate 50 days prior
to todays-date. This will be used for an AR report and I want to be
able to list accounts that have balances over 50 days.
You've gotten some COBOL replies on this. You might also see if however you're pulling the data can be constrained (i.e., including a date in a SQL "where" clause). That way, you're only addressing the data you need, instead of going through a lot of data and only processing certain entries.
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~ / \ / ~ Live from Montgomery, AL! ~
~ / \/ o ~ ~
~ / /\ - | ~ daniel@thebelowdomain ~
~ _____ / \ | ~ http://www.djs-consulting.com ~
~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~
~ GEEKCODE 3.12 GCS/IT d s-:+ a C++ L++ E--- W++ N++ o? K- w$ ~
~ !O M-- V PS+ PE++ Y? !PGP t+ 5? X+ R* tv b+ DI++ D+ G- e ~
~ h---- r+++ z++++ ~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
"Who is more irrational? A man who believes in a God he doesn't see, or a man who's offended by a God he doesn't believe in?" - Brad Stine
.
- Follow-Ups:
- Re: Report help
- From:
- Re: Report help
- References:
- Report help
- From: jeff
- Report help
- Prev by Date: Re: [OT] Rather Polite of Him, Wouldn't You Say?
- Next by Date: Re: Report help
- Previous by thread: Re: Report help
- Next by thread: Re: Report help
- Index(es):
Relevant Pages
|
|
