[AccessD] Date field sort

Stuart,

    Could you please verify again and confirm? Tests seem to indicate that data type of date type field in a query does not get affected by the settings in properties dialog box.

    On the other hand, if Format() function is explicitly applied on a date type field (e.g. in a calculated field), the result is a string.

Best wishes,
A.D.Tejpal
---------------

  ----- Original Message ----- 
  From: Stuart McLachlan 
  To: Access Developers discussion and problem solving 
  Sent: Saturday, January 06, 2007 04:54
  Subject: Re: [AccessD] Date field sort


  In the query design view, right click on the date field, select properties and make sure that the "Format" box is empty. If there is a date format in there, the data will be passed as a string, even if you use a CDate() expression.