I am trying to create a formula to chop up a date into seperate columns. I am using the LEFT (field name,2) and it is asking me for a string. What am I doing wrong? Also, what I am trying to do is pull the the first two digits from a date and then I want to create a formual to pull the middle 2 digits from the date and then another formula to pull the last 4 digits. so I can have individual columns for the dates. EX... change 06/07/2003 to show as three different columns. I know I would use the LEFT for the first two and use RIGHT for the last 4, but how do I get the middle two? This is where I am hitting the wall......