[AccessD] Date field sort

I stand corrected.

I was sure I'd seen that happen in the past, but apparently I was mistaken.


On 6 Jan 2007 at 11:28, A.D.TEJPAL wrote:

> 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.
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com

-- 
Stuart