AnsweredAssumed Answered

converting number sequence to dates

Question asked by ikaika7 on Feb 9, 2010
Latest reply on Feb 9, 2010 by ikaika7

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!

Outcomes