Diary (created between two dates)
###
Diary
###
Any rev01
###
Shows all diary notes created between two dates.
###
en
###
SELECT *
FROM diary
WHERE CreatedDate >= '$ASK DATE Notes between$' AND CreatedDate <= '$ASK DATE and$'
ORDER BY CreatedBy, CreatedDate
###
$$HEADER
HEADER$$

$$GROUP_CreatedBy
$$HEAD
<h2>$CreatedBy</h2>
<hr />
$$FOOT
GROUP$$

$$BODY
<p>
For $DIARYFORNAME - <i>$DIARYDATETIME</i> (completed on $DATECOMPLETED)<br />
<b>$LINKINFO $SUBJECT</b>
</p>
<p>
$NOTE
</p>
<hr />
BODY$$

$$FOOTER
FOOTER$$
&&&
Diary (outstanding between two dates)
###
Diary
###
Any rev01
###
Shows all incomplete diary notes between two dates.
###
en
###
SELECT *
FROM diary
WHERE DateCompleted Is Null
AND DiaryDateTime >= '$ASK DATE Notes between$' AND DiaryDateTime <= '$ASK DATE and$'
ORDER BY DiaryForName, DiaryDateTime
###
$$HEADER
HEADER$$

$$GROUP_DiaryForName
$$HEAD
<h2>$DiaryForName</h2>
<hr />
$$FOOT
GROUP$$

$$BODY
<p>
<i>$DIARYDATETIME</i><br />
<b>$LINKINFO $SUBJECT</b>
</p>
<p>
$NOTE
</p>
<hr />
BODY$$

$$FOOTER
FOOTER$$
