I need to be able to force the application to start up with the current date. I tried this with the formula:
=INSPDATE = Today()
in the Expression of the List Box. It creates a two row box with a 0 an -1, which allows me to click on the -1 and bring up Today's date, but does NOT force the current date on a regular reload. Any ideas? I'd rather just have it bring up the application with today's date already selected in the calendar. JPT
Go to Settings > Document Properties > Triggers and add an OnOpen action. Choose Select in Field, then put INSPDATE in the field box and =Today() in the expression.
If your field INSPDATE is not formatted as the system date is you may need to wrap Today() in Date().
Jason, I very much appreciate your help with this issue. I didn’t want to reply until I had a chance to give it a try, and I gave it several, but to no avail. I tried both the OnOpen and the OnPostReload Triggers, and I focused the field on the PeriodDate of the MasterCalendar. I cleared all selections and saved it, but upon opening … nothing. JPT
//Building the master calendar with most date dimensions
MasterCalendar:
load PeriodDate ,
Year(PeriodDate) & Month(PeriodDate) & NUM(Day(PeriodDate), 00) as LinkDate,
week(PeriodDate+1) as Week,
DateKey,
Year(PeriodDate) as Year,
Month(PeriodDate) as Month,
Day(PeriodDate) as Day,
Year2date(PeriodDate)*-1 as CurYTDFlag,
Year2date(PeriodDate,-1)*-1 as LastYTDFlag,
date(monthstart(PeriodDate),'MMM-YYYY') as ,
//if(week(PeriodDate)>= $(CurWeek) -3 and week(PeriodDate) <= $(CurWeek) and year(PeriodDate) = 2004,1,0) as FourWeekFlag,
Week(PeriodDate+1) as CalendarWeek,
Week(PeriodDate+1)&'-'&Year(PeriodDate) as WeekYear,
