i am in need to retrive content from acess with date/time datatype as constraint and its checking value is from datetimepicker of vb.net.
i have set both format of date as short format but getting datatype mismatch error in expression.
my coding:
dim bdate as date
bdate = datetimepicker_oneday.Value.Date
sSQL = " select * from register_details where hall_name='" & ucombobox_hallname.Text & "' and process_date='" & bdate & "' "
process_date
is an access field of date/time and short date format