~[if#1.prefschool.mobilehidephoto=1]
	~[SetPostValue:photodisplay=hide]
[else#1]
	~[if#2.~(studentscreenaccess;photo.html)=1]
		~[SetPostValue:photodisplay=show]
	[else#2]
		~[SetPostValue:photodisplay=hide]
	[/if#2]
[/if#1]
<ul id="birthdaylist" parentID="home" title="~[text:psx.html.admin_mobile.birthdaylist.birthdays]">
<li class="group">~[text:psx.html.admin_mobile.birthdaylist.birthdays_for,param:~[gpv:dateselect]]</li>~[tlist_sql; 
	SELECT
		CASE
			WHEN to_char(s.dob,'DD') = to_char(to_date('~[gpv:dateselect]','MM/DD/YYYY')-1,'DD')
				THEN 'prevDay'
			WHEN to_char(s.dob,'DD') = to_char(to_date('~[gpv:dateselect]','MM/DD/YYYY'),'DD')
				THEN 'currDay'
			WHEN to_char(s.dob,'DD') = to_char(to_date('~[gpv:dateselect]','MM/DD/YYYY')+1,'DD')
				THEN 'nextDay'
			ELSE 'feb29Day'
			END as dayClass,
		s.DCID,
		s.ID as id,
 		s.Last_Name, s.First_Name,
		CASE
			WHEN s.Grade_Level = -2 THEN 'PK3'
 			WHEN s.Grade_Level = -1 THEN 'PK4'
 			WHEN s.Grade_Level = 0 THEN 'K'
			WHEN s.Grade_Level = 1 THEN '1st'
 			WHEN s.Grade_Level = 2 THEN '2nd'
 			WHEN s.Grade_Level = 3 THEN '3rd'
 			ELSE to_char(s.Grade_Level) || 'th'
 			END AS Grade,
			round(months_between(to_date('~[gpv:dateselect]','MM/DD/YY'), s.dob)/12) HowOld
	FROM Students s 
		WHERE 1 = floor(months_between(to_date('~[gpv:dateselect]','MM/DD/YY')+1, s.dob)/12)
				  -
				  floor(months_between(to_date('~[gpv:dateselect]','MM/DD/YY')-2, s.dob)/12)
		AND s.Enroll_Status=0
		~[if.district.office][else]
		AND s.SchoolID = ~(curschoolid)
		[/if.district.office]
	ORDER BY 
		CASE WHEN to_char(to_date('~[gpv:dateselect]','MM/DD/YYYY'),'MMDD')
		  IN ('1231','0101') THEN to_char(s.dob+2,'MMDD')
		ELSE to_char(s.dob,'MMDD') END,
		LastFirst;nonemessage=<div class="info"><b>~[text:psx.html.admin_mobile.birthdaylist.no_birthdays_on_or_near_,param:~[gpv:dateselect]]</b></div>;makestudentselection]
	~[if.~[gpv:photodisplay]=hide]
	<li class="~(dayClass;t)">
		<a href="#student.html?frn=001~(s.DCID;l)&amp;parentID=birthdaylist">
			<!-- ~(id;l) -->
			~(s.last_name;t), ~(s.first_name;t)
	[else]
	<li class="~(dayClass;t)">
		<a href="#student.html?frn=001~(s.DCID;l)&amp;parentID=birthdaylist" style="min-height:120px;">
			<img src="/admin/stpnormal/~(id;l)ph.jpeg" alt="No Photo" border="0" height="120" width="120" align="left" style="padding-right:6px;"><br />
			~(s.last_name;t), ~(s.first_name;t)<br />
	[/if]	
			<span class="listSubHeading">(~(Grade;t))</span><br />
			<span class="listDetails">
			<span class="listDetails">
			~(Howold;l)~[text:psx.html.admin_mobile.birthdaylist.years]~(dayClass;t;if.test=prevDay;then=yesterday;else.if=nextDay;then=tomorrow;else.if=feb29Day;then=Feb 29;else=today)</span>
			</span>
		</a>
	</li>
	[/tlist_sql]

</ul>