Arthur Fuller
fuller.artful at gmail.com
Thu Aug 2 06:38:05 CDT 2012
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 > > >