Difference between revisions of "acc-wknd"

From MGH Learn Pathology
Line 2: Line 2:
 
<tr>
 
<tr>
 
<td class='align-bottom' colspan="1">
 
<td class='align-bottom' colspan="1">
<center>{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=YEAR(Date)='{{#expr: {{#timel: Y|}}}}' AND scheduleFACservice.DayNumber='6' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} + 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplaycurrent}}<p></p></center>
+
<center>{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=YEAR(Date)='{{#expr: {{#timel: Y|}}}}' AND scheduleFACservice.DayNumber='6' AND MONTH(Date)='{{#timel: m|}}' AND scheduleFACservice.WeekNumber='{{#expr: {{#timel: W|}} + 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplaycurrent}}<p></p></center>
 
</td>
 
</td>
 
<td class='align-bottom' colspan="1">
 
<td class='align-bottom' colspan="1">
<center>{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=YEAR(Date)='{{#expr: {{#timel: Y|}}}}' AND scheduleFACservice.DayNumber='7' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} + 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplaycurrent}}<p></p></center>
+
<center>{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=YEAR(Date)='2023' AND scheduleFACservice.DayNumber='7' AND MONTH(Date)='{{#timel: m|}}' AND scheduleFACservice.WeekNumber='{{#expr: {{#timel: W|}} + 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplaycurrent}}<p></p></center>
 
</td>
 
</td>
 
</tr>
 
</tr>

Revision as of 16:43, December 28, 2022