[AccessD] Date Comparison Problem

Gustav,

    I agree that "m/d/yyyyy" format for concatenation into a string should always give consistent results. Similar have been the findings with adoption of "dd-mmm-yyyy" format.

    One advantage of non-ambiguous format is that even if the programmer happens to slip up from standard sequence, the result still gets interpreted correctly. For example, all the following permutations will work OK:
    dd-mmm-yyyy, mmm-dd-yyyy, dd-yyyy-mmm, mmm-yyyy-dd, yyyy-mmm-dd, yyyy-dd-mmm.
    
    Are you in a position to test out and verify whether there is any specific situation where non-ambiguous format represented by "dd-mmm-yyyy" is not found to give consistent results ? Do you have some language other than English in mind ?

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

  ----- Original Message ----- 
  From: Gustav Brock 
  To: accessd at databaseadvisors.com 
  Sent: Thursday, March 30, 2006 23:48
  Subject: Re: [AccessD] Date Comparison Problem


  Hi A.D.

  That may not work as the literal month names are localized as well.

  /gustav


  >>> adtp at airtelbroadband.in 30-03-2006 20:04 >>>
   
  StrSQL = StrSQL & " WHERE TDate Between  #" & _
                   Format(StartDate, "dd-mmm-yyyy") & "#"