By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,475 Members | 2,060 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,475 IT Pros & Developers. It's quick & easy.

Text Format Date to Orginal Date Format

P: 2
Hi

I am new to MS-Access, I am getting the date in text format when I export it from other application. Could you please explain if there is any "Query" in Access to convert the text dates into original dates?

can some one explain in detail.

Regards-Mallik
Sep 20 '07 #1
Share this Question
Share on Google+
2 Replies


NeoPa
Expert Mod 15k+
P: 31,186
Mallik,
You first need to explain your situation more clearly. What formats of date are you using? Text dates & original dates mean nothing to us unless you explain that first.

The answer will almost certainly involve the Format() function, but until we have a question that makes sense we cannot give a clear answer.
Sep 20 '07 #2

Denburt
Expert 100+
P: 1,356
Yeah, lots of missing information first question are you importing this to MS Access, then you would like to convert the data?
You should be able to use CDate(FieldName) in a query to convert it and view as a date. as Neo stated please try to rephrase this question then we should be able to help a bit more.
Sep 20 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.