Search results

Yes, Paul. I tried exactly like that and it didn't work. Please find the sample attached. Tx.

It doesn't work when I enter the field name in the bracket. I have to apply the new formatting to the entire column that contains different dates.

Paul, thank you for your kind words. Heh, I thought my worries are gone but my input file got changed and now I have to deal with another format, see the following sample: Mar 1, 2008 I need to convert it to the same format mentioned above. My challenge is the first three characters that...

Mr. MVP, I appreciate your time and effort in helping me with this solution. All the best to you! Peter

O.K. so I had a partial success; I used the Mid formula as suggested and got the new string: Expr1: Mid([Field1],3,2) & "/" & Mid([Field1],5,2) & "/" & "0" & Mid([Field1],2,1) The remaining challenge is the DateSerial() function that I don't know how to apply in my case. Yes, I did read Help...

Thank you, Paul. I would need the entire formula since I am not expert in Access. Do you mind, please? Tx.

Is it possible to convert the text field that comes in this form: :80421 to the following datetime format: MM/DD/YY 12:00:00AM Please note that the text field contains a colon at the beginning. The number 8 represents a year (2008), the 04 represents a month (April) and the last two...