Hi. Thanks for the reply :)

yeah, i kind of hard code it or more accurate, I let user to input a date in format of dd/mm/yyyy

so, i have the code below.

$dDate = $_POST["dDate"];

then, i connect using odbc driver and run below codes to pass the sql to access.

$sql = "select * from staff where (datevalue(staff.entry) > datevalue('$dDate'))";
$result = odbc_exec ($conn, $sql);

after that, i retrieve result.

Hope this helps.

Thanks very much.