Stuart McLachlan
stuart at lexacorp.com.pg
Mon Aug 25 16:31:44 CDT 2003
On 25 Aug 2003 at 12:41, Bridget Doran wrote: > Hello > > Is it possible to convert a text field to a date field in Access2K? > > eg > 110403 to 11/04/03 > Assuming the 110403 is US style, ie MMDDYY myString = "110403" myDate = DateSerial(val(right$(myString,2)),val(left$(myString,2)),val(mid$(myS tring,3,2))) -- Lexacorp Ltd http://www.lexacorp.com.pg Information Technology Consultancy, Software Development,System Support.