Search results

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...

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...