F fhs Registered User. Local time Today, 08:19 Joined Aug 8, 2001 Messages 68 Feb 11, 2005 #1 How can you change the date format in an Update query from 2/7/2005 to 20050207? Thanx.
J Jon K Registered User. Local time Today, 08:19 Joined May 22, 2002 Messages 2,209 Feb 11, 2005 #2 You can't update a data/time field with the text string 20050207. However, you can update a text field in an Update Query or display a new field in a Select Query with the following expression:- Format([DateFieldName],"yyyymmdd") .
You can't update a data/time field with the text string 20050207. However, you can update a text field in an Update Query or display a new field in a Select Query with the following expression:- Format([DateFieldName],"yyyymmdd") .
F fhs Registered User. Local time Today, 08:19 Joined Aug 8, 2001 Messages 68 Feb 12, 2005 #3 fhs That's exactly what I was looking for. Thank you very much.
