Great idea Albert, I was just doing something like this and buttons are the obvious choice, now that you have mentioned it!
Thanks Dennis McGrath -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Albert Berry Sent: Tuesday, May 11, 2010 10:32 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: RCALENDAR If your calendar object is a variable calendar you can set the variable to the requested date in the [on after start] eep. If your object is a database calendar, you could replace it with a variable calendar, assign the variable 01/01/2009 as the date, and equate the column to the variable value. On some forms, I have buttons to select particular dates for reports. One way to get the first of January last year is to use this formula to set the variable for the beginning of last year. SET VAR vDate1 DATE = (RDATE(1,1,(IYR4(ADDYR(.#DATE,-1))))) You could create a button to run an eep to set [First Half Last Year] for example, using the following code SET VAR vDate1 DATE = (RDATE(1,1,(IYR4(ADDYR(.#DATE,-1))))) SET VAR vDate2 DATE = ( (ADDMON(.vDate1,7)) - 1) RETURN Albert I also do similar things with [Last Month] [Today] [Last Week] etc. Jim Belisle wrote: > > Is there a way to copy the Rcalendars (either 6 months or 12 months) > and make them come up with the January 2009 date as the first date? > > I have them in my database coming up with this years January as the > first month. > > If I make the form itself have a compID of Comp_C12 (for the 12 month > calendar) would I use the PROPERTY COMMAND? > > > > Jim > > > > >
