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
