formatDate Function – Formatting Dates in NetSuite

This article will focus on the formatDate function, its purpose, and how it converts dates into a specific format. The function accepts a date string in the format “DD-MONTH-YYYY” (e.g., “15-JANUARY-2024”) and converts it to “MM/DD/YYYY” (e.g., “01/15/2024”). Here’s what the article could include:

1. Introduction: Explaining the importance of date formatting in NetSuite scripts.
2. Code Breakdown: Discussing the logic of splitting the date string and mapping month names to numeric values.
3. Common Use Cases: Where this type of date formatting would be required in NetSuite customizations.

function formatDate(dateString) {
    var dateParts = dateString.split(' ')[0];
    var [day, month, year] = dateParts.split('-');
    var monthMapping = {
        "JANUARY": "01",
        "FEBRUARY": "02",
        "MARCH": "03",
        "APRIL": "04",
        "MAY": "05",
        "JUNE": "06",
        "JULY": "07",
        "AUGUST": "08",
        "SEPTEMBER": "09",
        "OCTOBER": "10",
        "NOVEMBER": "11",
        "DECEMBER": "12"
    };
    var monthNumber = monthMapping[month.toUpperCase()];
    var formattedDate = monthNumber + '/' + day + '/' + year;
    return formattedDate;
}