Im having a little problem with my datetimepicker!Im making a personal payroll system,where I want to add employee's daily hours!for example:
Employee name:Marcus Veron
19/07/2012 | 8
20/07/2012 | 8
21/07/2012 | 7
Well im having problem quering the date field...cause in my datetimepicker i have it custom formated to dd/MM/yyyy but in the database its MM/dd/yyyy.I guess thats where the problem is.When I run this query "Select * From WorkedHours where EmployeeID="employee ID" and PayrollID="Payroll ID" and Date="dtphours.text".
I want it to look if the date exist then update the hours if not then create new registry.How do I do this?I have tried formating the dtp but still it doesnt read the date!!please Help!!