IDIM might help. This gives you the number of days in the month. Then you can use that info to have a IF THEN clause based on the month you get. The ILY you may need as well to care for your leap year.
James Belisle Making Information Systems People Friendly Since 1990 [cid:[email protected]] From: [email protected] [mailto:[email protected]] On Behalf Of Kaleb Wade Sent: Wednesday, February 01, 2017 8:07 AM To: RBASE-L 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]<mailto:[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.
