Date format problem

[mozaharul]

Hi,

Attached is a sample application where the problem occurs when the DateTimePicker date happens on the same date or later than the date stored (with timestamp) in the database.

I have used two diffrent date format in the application, because the age of individual stored in the database (not shown) is in "dd/mm/yyyy" format. "agecal" calculates the age.

if the date is current one then ask for confirmation, works OK.

if the date happens before the date (l_update) stored in the database then ask for confirmation, works OK.

Please have a look and help.


regards,

 

[Erel]

Not sure I understood the problem.
I recommend you to declare the columns as TEXT instead of date. It may solve your problem.