[AccessD] Un-American Date Filter

Doug Steele dbdoug at gmail.com
Fri Apr 1 00:38:39 CDT 2011


Yes, you bet.  In Canada, April Fool's day rules!!

Doug

On Thu, Mar 31, 2011 at 10:30 PM, Stuart McLachlan
<stuart at lexacorp.com.pg> wrote:
> dd Mmm yyyy .... in sequential order.  (?)
>
> You mean "01 Apr 2011"  comes before "01 Jan 2011"  in your calendar?
>
> --
> Stuart
>
> On 31 Mar 2011 at 21:54, Jim Lawrence wrote:
>
>> Actually, our government (federal and provincial) uses yyyymmdd which
>> sorts as a string, a number or as a date without any translation. The
>> other date standard they use is dd Mmm yyyy; ie. 01 May 2011 so there
>> is never any confusion between month and day...and again everything is
>> in sequential order.
>>
>> Jim
>>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>




More information about the AccessD mailing list