Hi,
I am trying to write a customised MS Access application to extract data from the MySQL database about attendance, mainly because I don't know enough about PHP. Everything is working well and my queries are great for what I need but I can't figure out the "sessdate" field in the mdl_attendance_sessions table. The formatting on my database gives a value such as 1156978800 or 1157065200. The date appears correctly on the Moodle pages but I don't know how to make these number make sense. I understood from searching these forums the date is d,m,y but this doesn't work.
Here is the code I am looking at from add.php for the generation of the sessdate field.
if ($mode === 'one') {
$sday = required_param('sday', PARAM_INT);
$smonth = required_param('smonth', PARAM_INT);
$syear = required_param('syear', PARAM_INT);
$desc = required_param('desc');
$sessdate = mktime(0, 0, 0, $smonth, $sday, $syear);
Can anyone help? How do I interpret these numbers in the table?
I have attached a screen dump of access so you can see the table.
Many thanks,
Duncan