(SELECT IDCourse as Expr1, 'Class' as Expr2, Type as Expr3, Description, DateStart, DateEnd, LocationName, Cost, Notes FROM Course, Location WHERE Course.IDLocation = Location.IDLocation AND DateEnd >= {ts '#TempFirstDayOfMonth#'} AND DateStart <= {ts '#TempLastDayOfMonth#'} ORDER BY DateStart) UNION ALL (SELECT IDEvent as Expr1, 'Event' as Expr2, 'Null' as Expr3, Description, DateStart, DateEnd, LocationName, Cost, Notes FROM Event, Location WHERE Event.IDLocation = Location.IDLocation AND Status = 'Active' AND DateEnd >= {ts '#TempFirstDayOfMonth#'} AND DateStart <= {ts '#TempLastDayOfMonth#'} ORDER BY DateStart) SELECT Date, Description FROM Holidays WHERE Date >= {ts '#TempFirstDayOfMonth#'} AND Date <= {ts '#TempLastDayOfMonth#'} "&#Description#>
schedule





#DateFormat(TempSelectedMonth,"mmmm")#




MONDAY
TUESDAY
WEDNESDAY
THURSDAY
FRIDAY
SATURDAY
SUNDAY
 
#TempCountDayOfMonth#
#Mid(ArrayActivities[TempCountDayOfMonth][Loopindex],21,Len(ArrayActivities[TempCountDayOfMonth][Loopindex]) - 20)# #Mid(ArrayActivities[TempCountDayOfMonth][Loopindex],21,Len(ArrayActivities[TempCountDayOfMonth][Loopindex]) - 20)#
#Mid(ArrayActivities[TempCountDayOfMonth][Loopindex],11,7)# #Mid(ArrayActivities[TempCountDayOfMonth][Loopindex],10,8)#
TDSB Studio
#ArrayActivities[TempCountDayOfMonth][1]#