Search results

I am importing data from a text file that contains dates in this format: 08012007 I am trying to convert the number to a date 08/1/2007 so that I can run date related queries. Your help is appreciated - Thank you.

My first post ever... so here goes. My Goal: Columns of data contain date fields & "Status" that indicates where a case lies. I'm trying to calculate days spent in a specific area (determined by status code) and total amount of time spent there all together. Status code begining w/ "I***"...