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 >