[RBASE-L] - Re: Day of week insert - Follow-Up :End-Of-Month

[A. Razzak Memon]

Steve,

You can always use (ADDDAY(ColName,-1)) to get the
previous date of any given DATE column/variable!
A quick example #1:

SET VAR vPrevDate DATE = NULL
SET VAR vPrevDate = (ADDDAY(.#DATE,-1))
SHOW VAR vPrevDate
Example #2:

SET VAR vLastDate DATE = 12/31/2003
SET VAR vPrevDate DATE = NULL
SET VAR vPrevDate = (ADDDAY(.vLastDate,-1))
Now imagine the possibilities!

For more examples: http://www.RSyntax.com

Have fun!

Very Best R:egards,

Razzak.

At 09:49 AM 12/12/2003 -0600, Steve in Memphis wrote:


Bill, Et Al., would anyone know of a good way (algorithm) and RB
implementation/approach to finding the end of a series of months?  For
example, let's say that we have a need to allow a user to create a new YEAR,
with 12 months (we won't worry for now whether it's Fiscal or Calendar).  We
know that each month's first day is an (INTEGER) 1 ...
Hey, wait a minute, if each month in a given period is known, and each month
starts with a 1, the first, as it were, then the end of the previous month
can be derived by subtracting one date from the first, right?
Anybody have any experience/insights in this area?

Thanks,
Steve in Memphis
----- Original Message -----
From: "Bill Downall" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[EMAIL PROTECTED]>
Sent: Thursday, December 11, 2003 7:07 PM
Subject: [RBASE-L] - Re: Day of week insert
> Define a variable
> vWeekDayName TEXT = (TDWK(datecolumn))
>
> Locate the variable anywhere you like. Or, just define the picture format
of
> the column to show the weekday.
>
> Bill
>
>
>
> On Thu, 11 Dec 2003 20:13:45 -0500, Steve Breen wrote:
>
> >I appreciate this information. How would you include this as an
> expression
> >in a report?
>
> >I was thinking in simple terms: day = (TDWK(datecolumn))
>
> >But I have my doubts that this will work. I believe I am thinking in the
> >wrong direction here
>