This is what I use to get last day of the month:
SET VAR vEndDate DATE = ((ADDMON(.vStartDate,1))-1) Are you using DOS? If you aren't, I'd suggest getting away from using the "fillin" command. That's an old holdover from DOS days, I wouldn't be surprised if at some point it becomes an obsolete command. Use Dialog instead. Karen -----Original Message----- From: Kaleb Wade <[email protected]> To: RBASE-L <[email protected]> Sent: Wed, Feb 1, 2017 8:07 am Subject: [RBASE-L] - date question I am trying to set two variables using one date given by user. Whatever date is given by user, I want to find the first date of the month and the last date of the month. Below is a simplified version of what I am trying to do. FILLIN vdate1 USING 'ENTER THE DATE :' SET VAR vdate3 = (RDATE((IMON(.vdate1)),01,(IYR(.vdate1)))) SET VAR vdate4 = (RDATE((IMON(.vdate1)),31,(IYR(.vdate1)))) The first date of the month is working fine. I cannot figure out how to get the last date of the month, since there are a different number of days in each month. Does anyone have a suggestion? Thank you! -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
