hrmm. ok BJ, I started working on the fix date script a minute ago and a problem hit me.
mxm only reports the year in 2 digit format.
the display of the date can be changed by the user to be a number of different ways: yy/mm/dd or mm/dd/yy
I was going to use SETFUNC CurrentYear Right 4 $date$ to get the year (i know i must use Right 2 for now)
This poses a couple problems.
1. I dont know which section might contain the year.
2. I was needing the long year to check the first digit of the year for a 2, to see if it was invalid. So if a box had 8907 (or whatever the year was) the user could be prompted to fix the date. if it was 2040, or 2004 or 2003 ..then it wouldnt.
Is there any way to pull the full date from the box without the mxm mods to two digit format..and always in the same display format? so i could expect $realdate$ to always display mm-dd-yyyy
well.. for the next few years i can check jsut for the right digit of 8907 and if its 7, then its invalid.
but the user will have to know/remember/leave the year to mm-dd-yy format, or it will be an AFu script for now.