Any of the following could be used on Sunday, January 3, 2009 to define the first week of the month.
The same could be accomplished on Saturday, January 2, after all other processing was completed, with TWEEK (by itself, instead of LWEEK) or the other examples preceding.
If the definition of a reporting day was 8:00 a.m. to 8:00 a.m., the first situation would be specified as either of the following:
If the reporting job was to run on Saturday, January 2, the literal in this second example would also have to be TWEEK instead of LWEEK.
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|