SIMS report to output students who have a birthday today
I've been asked to see if its possible to show a "Happy birthday to" section on our digital signage. The easiest way I can see it is to get sims to report the names and for me then to "perl" these into a web page or rss feed that the digital signage software (Xibo) will pull down and display.
I just need to know a) how to run a sims report on a schedule (it has to be automated!) and b) how to get the sims report to default to "today" for the matched DOB filter.
If only I could do a "select name, surname, dob from 'students' where 'students.dob' eq %todaysdate% "
Any ideas appreciated.
(ps don't pick me up on my sql syntax it was just to demonstrate how easy it should be to get at the information in SIMS!_)