Thanks Razzak,
That will work for me.
Any thoughts on how I might accomplish the desired results from
LoadFileName.rbl?
(see prior emails)
Bernie
----- Original Message -----
From: "A. Razzak Memon" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Thursday, July 03, 2008 9:24 PM
Subject: [RBASE-L] - Re: addmon
At 08:57 PM 7/3/2008, Bernard Lis wrote:
What I want is the beginning of the month date ...
Here's a technique that will give you the first and last date
of the month:
-- start here ...
CLEAR VAR vStartDate,vEndDate
SET VAR vStartDate DATE = NULL
SET VAR vEndDate DATE = NULL
SET VAR vStartDate = (RDATE((IMON(.#DATE)),1,(IYR4(.#DATE))))
SET VAR vEndDate = ((ADDMON(.vStartDate,1))-1)
-- end here ..
And, here is a visual presentation of such technique:
http://www.razzak.com/sampleapplications/Start_End_Date_01.jpg
http://www.razzak.com/sampleapplications/Start_End_Date_02.jpg
http://www.razzak.com/sampleapplications/Start_End_Date_03.jpg
Enjoy!
Very Best R:egards,
Razzak.
