Quote:
Originally Posted by
SIMMS7400
Hi Don -
... ... ...
And yes, you are right, if run during those special occasions, my code would be wrong for quite a few variables. My next task was going to be trying to solve for that.
1. ALLC_CurrentWeek - Day in which script is ran
2.ALLC_CurrentPeriod - Assumes the same behavior of what we spoke about before, your posy #18.
3.PriorQuarterAD - Same concept as post #18.
4.CurrentQtrInput -Same concept as post #18
5.PriorQtrInput - Same concept as post #18.
For instance, if day (Saturday which is the day the script is ran) is 12/31, ALLC_CurrentWeek would be 12/31/16, ALLC_CurrentPeriod would be Jan, and PriorQuarter would be De, CurrentQtrInput would be Jan, and PriorQtrInput would be Dec.
Thank you, Don!
You're giving examples again; not definitions. And the strings associated with these values do not correlate with the values you seem to want following them.
You seem to be saying that
ALLC_CurrentWeek is a synonym for
CurrentWeek. Why have two names for the same thing? If they aren't the same, what is the difference between them?
Note that I say the names don't correlate to the strings because a day (
12/31/16) is not a week (12/31/16-01/06/17), but the string you put before the output specifying the Saturday at the start of the week in which you invoke this program is named
CurrentWeek (and maybe also
ALLC_CurrentWeek). Sometimes you call a month a
Period and sometimes you call a month a
Mnth and in your examples above you seem to be calling a month a
Qtr. Naming something
PriorQtrInput and assigning it a value that is an abbreviated month name provides me with no mnemonic relationship.
Please define the above terms in English; not just with examples from which you hope I'll be able to guess at a definition.