Recent content by turbojo1

Thanks for your help. You have given us a idea on how to proceed!!

A sample of the table structure is as follows: **sorry I have tried to line up the example below with no success. the first number is the EmpId, the second number is the UnitId and text just signifies the note. EmpID UnitID Note 100 05 text 100 05 text 150 05 text 175 10 text 200 10 text...

Hello, I will try to make this as simple as possible. We have a department with multiple units. Each unit has a unique ID. Within each unit, each employee in those units also have unique ID's. As employees interact with customers they make notes on the customers accounts and assign the notes an...

a value such as 2009 would be 07309. doesn't make sense to me either but thats what I am stuck with. in the past the text value would just be separated into 3 different fields in a table, the year would then be corrected then all 3 concatenated into a date format. I was hoping for something...

I have a date value in text format that is 5 character and want to convert it to a proper date format. Here is a sample of the data: 07301 actually represents 7/30/2011. can anyone help me actually convert that value to the date format of mm/dd/yyyy? thanks!