[AccessD] International date format problem

Stuart McLachlan stuart at lexacorp.com.pg
Thu Aug 2 16:06:49 CDT 2012


Try Datevalue("2/6")  :-)


On 2 Aug 2012 at 7:38, Arthur Fuller wrote:

> Pursuant to this thread, I decided to try a few things:
> 
> ? DateValue("2102-02-02")
> 2/2/2102
> ? DateValue("Jun-21-12")
> 6/21/2012
> ? DateValue("21-Jun-12")
> 6/21/2012
> ? DateValue("2012/06/02")
> 6/2/2012
> ? DateValue("21/Jun/12")
> 6/21/2012
> ? DateValue("2012.06.02")
> --> Type mismatch
> 
> These are the only date formats I could think of at the moment. Conclusion:
> DateValue() works almost all the time.
> Arthur
> 
> On Thu, Aug 2, 2012 at 3:16 AM, Gustav Brock <gustav at cactus.dk> wrote:
> 
> > Hi Rocky
> >
> > Welcome to reality. But where have you been all these years? This is a
> > classic that has been up over and over again.
> >
> > /gustav
> >
> >
> >
> -- 
> 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