### Title

converting number sequence to dates

### Post

Hello, I'm new to FMP and I have version 7. I was wondering how to convert a field containing a number sequence to represent a specific date. The number sequence can be anywhere from one digit to five digits in length.

This field is divided in the following manner. The 1st digit is the year, the 2nd two digits are the month and the last two digits are the day of the month. Thus, 00616 would represent June 16, 2010. Thus, 00600 would represent June 2010. (NOTE! 10600 would represent June 2011.)

Thank you!

I dont agree with your numbering system but....

Let ( x = YourField;

Date ( Middle ( x; 2; 2 ); Right ( x; 2 ); 2010 + Left ( x; 1 ) )

)