Attendance report for daily bulletin (teachers)

We were given a code for daily attendance that we could put into a daily bulletin for our teachers. I find it really helpful, but the original item was set up for daily attendance, and we do period attendance.

I changed the attendance mode code and everything works great. However, I would like to change the column that has the date to having the period number.

There is no reason to have a date column, as the date is on the top.

The code I need to change is:

~(att.att_date;d)

Does anyone know how to change that to reflect the period number instead of the date? I've tried a number of things, but just can't get it! The report is working great otherwise.

This is the whole code:

Student
Current Grade Level
Attendance Date
Code

~[tlist_sql;
SELECT
s.lastfirst,
s.grade_level,
att.att_date,
ac.att_code
FROM attendance att
INNER JOIN attendance_code ac ON att.attendance_codeid = ac.ID
left outer JOIN attendance_time attt on attt.attendanceid = att.id
INNER JOIN students s on att.studentid = s.id
WHERE att.att_date='~[bulletindate;0]'
AND att.yearid=22
AND att.att_mode_code='ATT_ModeMeeting'
AND ac.att_code is not null
AND att.schoolid=2
ORDER BY s.lastfirst,att.Att_Date;alternatecolor]

~(s.lastfirst;t)
~(s.grade_level;l)
~(att.att_date;d)
~(ac.att_code;t)

[/tlist_sql]

Legend
Attendance Codes: ~[x:att_code_legend;if.blank.then=Blank]

I just did a daily bulletin that shows to only teachers for this, and the list generates fine, and the student is listed for each period that he misses with the correct attendance code. However, I would like to view the period numbers.

Any help would be appreciated!