G Guest Jun 21, 2004 #1 What is the SQL command to change this date format January 2003 to 1/1/2003. Thanks
M Michel Walsh Jun 22, 2004 #2 Hi, CDate( "1 " & MonthYearValue ) the concatenation would make "1 January 2003", CDate should be able to understand this is the first of January, 2003, with most regional settings understanding English month name. Hoping it may help, Vanderghast, Access MVP.
Hi, CDate( "1 " & MonthYearValue ) the concatenation would make "1 January 2003", CDate should be able to understand this is the first of January, 2003, with most regional settings understanding English month name. Hoping it may help, Vanderghast, Access MVP.
