I have written an application in VB6 to take in SMS messages from a SIM card and store them as Alarms in a MYSQL database. Each Alarm is stored in the database with the date and time of the alarm.
I need to add a function to the application to only display the alarms that came in in the Last 24 Hours. Does anyone know how I might achieve this?
I was trying something along the lines of using the VB function Time() and subtractung the time of the alarm from it?
Any suggestions would be grately appreciated.