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.
