I was using this calculation to convert a date from dd-mm-yyyy:
adj =Substitute ( Self ; "-" ; ¶ ) ;
month = GetValue ( adj ; 2 ) ;
day = GetValue ( adj ; 1 ) ;
year = GetValue ( adj ; 3 )
Date ( month ; day ; year )
All was well, until the format of the spreadsheet from which I import data changed. Now it's dd-mmm-yyyy, as in "08-jun-2014."
Now, my dates all are converted to something between 12/1/2013 and 12/31/2013. What is happening? I assume it has to do with the text month.