In my DB, I have a date field. The default format is set as 'dd-mm-yyyy'. I have made query to view the records of a particular day. On hitting the command button which is linked to the query, it asks for the Date input.
Now comes the strange behaviour of the query. If I type 04-06-2007 (i.e. 4th June 2007), records of 06-04-2007 (i.e. 6th April 2007) are shown. If I type 06-04-2007, records of 4th June 2007 are displayed. Why is this strange behaviour? How can I correct this problem? Please help.
Now comes the strange behaviour of the query. If I type 04-06-2007 (i.e. 4th June 2007), records of 06-04-2007 (i.e. 6th April 2007) are shown. If I type 06-04-2007, records of 4th June 2007 are displayed. Why is this strange behaviour? How can I correct this problem? Please help.
