Recent content by mjfigur

Thank you for your help I will have to go in this morning and make sure there is consistancy is the data coming in so that it would not confuse the DateSerial. Just one other question when I try and input this: DateSerial(Right([Demand Date],4),Left([Demand Date],2) Mid([Demand Date],3,2))...

Sure thing sorry about that it is currently mmddyyyy but in text format

Ok I am pretty new to access and was given a large database to work on with a prior developer leaving the company. I have a field named: Demand Date that comes over from a linked table in text format (ex. 1152009). While working in my select query I need to convert this to a date format...