PERTALIFE

01/13/2025

09:57 AM Document: QUERY buat cek data attendance di face recognition yang ada di file tarikan extension MDB (versi compare sama db minova format tanggal nya )

SELECT Format(USERINFO.Badgenumber,"00000000") AS IDN, USERINFO.Name AS Name, Format(DateValue([CHECKTIME]),"yyyymmdd...

01/03/2025

04:11 PM Document: QUERY buat cek data attendance di face recognition yang ada di file tarikan extension MDB

SELECT USERINFO.Badgenumber AS IDN, USERINFO.Name AS Name, DateValue([CHECKTIME]) AS Tanggal, Min(IIf(UCase(CHECKINOU...