slraymond

Converting Date from dd-mmm-yyyy

Discussion created by slraymond on Sep 4, 2014
Latest reply on Sep 4, 2014 by slraymond

I was using this calculation to convert a date from dd-mm-yyyy:

 

Let([

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.

Outcomes