Difference between revisions of "Schedule"

@@ Line 50: / Line 50: @@
      |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|{{Timezone}}}} - 0 }}' AND scheduleCallConference.DayNumber='{{#expr: {{#timel: N|{{Timezone}}}} - 0 }}'|default=''No scheduled conferences''
+     |where=YEAR(conferenceMPR.Date)='{{#timel: Y|now}}' AND conferenceMPR.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND conferenceMPR.DayNumber='{{#expr: {{#timel: N|{{Timezone}}}} - 0 }}'|default=''No scheduled conferences''
      |format=template|template=schtableconf}}
 {{#cargo_query: tables=scheduleCallConference,residentMGH