Thanks. I had an idea of how to use, because I had a similar scenario to this in my coursework for A level ICT. That was using Microsoft Access though

Think it was something like <date() or something in that case. I just didn't know how to do it in SQL.
Thanks for your time.