Difference between revisions of "Schedule"

@@ Line 47: / Line 47: @@
 <td style="width: 25%">
 <table class='scheduletable'><tr><td bgcolor="#f5f5f5"><center>{{ColorText|'''Conference'''||#000000|}}</center></td></tr></table>
-W = {{#expr: {{#timel: W|now}} - 0 }}
-Y = {{#timel: Y|now}}
-N = {{#expr: {{#timel: N|now}} - 0 }}
 {{#cargo_query: tables= conferenceMPR,residentMGH
      |join on=conferenceMPR.ResAbbrev=residentMGH.copath_id
      |fields=conferenceMPR.ResAbbrev,conferenceMPR.Color,residentMGH.full_name
-     |where=YEAR(conferenceMPR.Date)='{{#timel: Y|now}}' AND conferenceMPR.WeekNumber='{{#expr: {{#timel: W|now}} - 0 }}' AND conferenceMPR.DayNumber='{{#expr: {{#timel: N|now}} - 0 }}'|default=
+     |where=YEAR(conferenceMPR.Date)='{{#timel: Y|now}}' AND conferenceMPR.WeekNumber='{{#expr: {{#timel: W|now}} - 0 }}' AND conferenceMPR.DayNumber='{{#expr: {{#timel: N|now}} - 1 }}'|default=
      |format=template|template=schtableconf}}
 {{#cargo_query: tables=scheduleCallConference,residentMGH