How to separate am and pm time

snizer20 · Post by **snizer20** » Wed Mar 15, 2017 3:36 pm

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

mobhar · Post by **mobhar** » Wed Mar 15, 2017 4:22 pm

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.

snizer20 · Post by **snizer20** » Tue Mar 21, 2017 10:01 pm

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.

mobhar · Post by **mobhar** » Wed Mar 22, 2017 9:20 am

Please post your data sample for more discussion.