Convert MM/DD date format to YYYY-MM-DD
Question:
I've gone forums and date questions haven't seen one like mine. The date that extracted string, however, is in the MM/DD format. Excel doesn't know yet...
Solution:
You can use JavaScript to convert the MM/DD date format to YYYY-MM-DD format.
Code:
function convertDateFormat(date) {
const parts = date.split('/');
const year = parts[2];
const month = parts[0];
const day = parts[1];
return `${year}-${month.padStart(2, '0')}-${day.padStart(2, '0')}`;
}
const date = '01/02';
const formattedDate = convertDateFormat(date);
console.log(formattedDate); // Output: 2023-01-02
Output:
References:
- Book: Eloquent JavaScript, 3rd Edition
- Article: String.prototype.padStart()