04-20-09, 10:41 #1Registered User
- Join Date
- Mar 2004
Unanswered: Convert 10.10.00 date to 10/10/00 date format
I have fields with a format of 10.10.00
but when i attenmpt to convert them to dates it errors and says that it will delete them. I assume I have to do something the excel end (source) as it is a form that when changed to date format still shows 10.10.00 rather than the select 10/10/00
Any help on how I can do this via Excel or Access - even if it means using a formula in Excel to convert the dates?
04-20-09, 12:16 #2Moderator
Provided Answers: 19
- Join Date
- Jun 2005
- Richmond, Virginia USA
This is getting to be very aggravating! I posted an answer to this thread a while ago, as did someone else. Came back to check it and both responses are gone. Checked, and the question wasn't double posted. This is not the first time this has happened. Where do you report problems?
In VBA code:
Format(CDate(Replace(StringDate, ".", "/")), "dd/mm/yy")
or in a Query
ConvertedField: Format(CDate(Replace(StringDate, ".", "/")), "dd/mm/yy")
Last edited by Missinglinq; 04-20-09 at 12:19.Hope this helps!
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007