Hi! i'm also a newbie and i'm using phpmaker2017
i have Biometrics Ms Access database , how to separate the am/pm time record because they are in one field, and i want them to split to make an In and Out field. Thankyou
Just alter the table to add those two new fields, and then use UPDATE statement to update the value for those fields based on the last two character from the original field.
i'm currently making an attendance monitoring system using biometrics and i have "Clock" field from the biometrics database that contains "Date and Time" records and i already separate the Date to another field and my problems is how to separate the AM time and PM time also to another field, because in view tag the only available format is "Time(AM/PM)" only ..
Thankyou.
Please post your data sample for more discussion.