1. Date & Time format:
function formatInputDate(inputData) {
// Split the input by space to separate date and time
var parts = inputData.split(' ');
// If the input data is not empty
if (parts.length === 2) {
var datePart = parts[0];
var timePart = parts[1];
// Split the date by '/'
var dateParts = datePart.split('-');
// Ensure that there are three parts ["2023","02","15"]
if (dateParts.length === 3) {
var month = dateParts[1];
var day = dateParts[2];
var year = dateParts[0];
// Pad the month and day with leading zeros if needed
month = (month.length === 1 ? '0' + month : month);
day = (day.length === 1 ? '0' + day : day);
// Concatenate the parts in the required format
var outputDate = year + '-' + month + '-' + day + ' ' + timePart; // + ':00'
return outputDate;
} else {
return "";
}
} else {
return "";
}
}
2. Add Leading Zeros:
var applicantEmployeeNumber = '2343'; //Employee Number
var desiredLengthString = 8; // Desired length (including leading zeros)
var paddedappEmployeeNumber = applicantEmployeeNumber.toString(); // Pad Leading zeros if needed
while (paddedappEmployeeNumber.length < desiredLengthString) {
paddedappEmployeeNumber = '0' + paddedappEmployeeNumber;
}
3. New use-case placeholder