Search results

Ok, so it's not a date anymore but it works! Thanks so much!

Hi! Our system is currently using dates in this format: 20140306 = 3/6/14 The expression I am using to convert this to a regular date in a query is: DateSerial (Left([fieldname],4),mid([fieldname],5,2),Right([fieldname],2)) which changes it from 20140306 to 3/6/14 and works perfectly...

Yes, it does work! You are wonderful, thank you. Apparently it had worked before, the #Error was because the field for those particular rows did not have any data in the column I was converting. I just didn't page down far enough. Thanks so much! Brenda

Here is a mini database with the date formats.

Ah, one problem solved. The field is for "origin date" which is what I used in my expression, but they named it "ORGIN DATE" (it's a UDF), so that's what happened. However, I tried DateSerial and the result is a column of #Error, and the DateValue still says my expression has a function...

Thank you, Paul. I tried that but it still asks me for a parameter value for my date field.

Hello. I see many similar topics but unfortunately I still am doing something wrong. My date field is in text format and looks like this: 20121102 (yyyymmdd) Here is what I've tried: DATEVALUE(LEFT([FIELDNAME],4),MID([FIELDNAME],5,2),RIGHT([FIELDNAME],2)) Result: The expression you...