Convert "dd/MM/yyyy hh:mm tt" To "yyyy-mm-ddThh:mm" In Javascript

Question

I have date in "dd/MM/yyyy hh:mm tt" format eg. (25/05/2023 2:30 PM).

And I want to convert it into "yyyy-mm-ddThh:mm" this format eg. (2023-05-25T14:30) by using Javascript.

I tried like this:

console.log(new Date("25/05/2023 2:30 PM"));

But It's showing as "Invalid Date"

Answer 1

You could extract the date parts and build the date string manually, like so:

const mydate = "25/05/2023 2:30 PM";

console.log( dateFormatter(mydate) );

function dateFormatter(datestr){
  const regex = /^(\d{2})\/(\d{2})\/(\d{4}) (\d{1,2}):(\d{2}) ([AP]M)$/;
  const match = datestr.match(regex);

  if( ! match )
    throw new Error('Invalid date format')
  
  // pull out the date parts
  const parts = match.slice(1);
  let day     = parts[0]; 
  let month   = parts[1];
  let year    = parts[2];
  let hours   = parseInt(parts[3], 10); // must be int to add 12 for 24H
  let minutes = parts[4];
  
  // change 12H to 24H
  hours += (parts[5] == 'PM' ? 12 : 0);
  
  // pad hours to two digits
  hours = ('00'+hours).substr(-2);
  
  // format any way you like: 
  return `${year}-${month}-${day}T${hours}:${minutes}`; 
}

Javascript sadly does not support the /x flag or custom delimiters in regexes, like Perl does. So the regex is a little crammed and suffers from leaning toothpicks.

Otherwise, it is pretty straight forward.

Answer 2

Fairly simple to parse the timestamp to get the values and reformat as required after converting the hour to 24 hour clock, e.g.

let timestamp = "25/05/2023 2:30 PM";

// Get the values
let [day, month, year, hour, min, ap] = timestamp.match(/\w+/g);

// Convert hour to 24 hour
hour = (/am/i).test(ap)? hour : +hour + 12;

// Pad hour to 2 digits
hour = ('0' + hour).slice(-2);

// Format as required
console.log(`${year}-${month}-${day}T${hour}:${min}`);

You should add some validation and checking along the way to avoid errors if the timestamp isn't guaranteed to meet the OP format.

Answer 3

You can split the date and combine it in required format. Once you get the format you can pass the string to date object and you can then use that date however you like in your application. Here is one such example.

const initialDate = "25/05/2023 2:30 PM";
const dateParts = initialDate.split(' ');
const timeComp = dateParts[1] + " " + dateParts[2];
const dateSplit = dateParts[0].split(/\//);
const dateComp = [dateSplit[2], dateSplit[1], dateSplit[0]].join('-') + " " + timeComp;
const parsedISODate = new Date(new Date(dateComp).toString().split('GMT')[0] + ' UTC').toISOString();
console.log(parsedISODate);

// If you need to remove last part after minutes
const finalDate = parsedISODate.toString().substring(0, parsedISODate.toString().lastIndexOf(':'));
console.log(finalDate);

Answer 4

The resulting formattedDate will be in the desired "yyyy-mm-ddThh:mm" format, which in this example will be "2023-05-25T14:30".

Try below Code :

// Input date string in "dd/MM/yyyy hh:mm tt" format
var inputDateStr = "25/05/2023 2:30 PM";

// Split the input date string into its components
var dateComponents = inputDateStr.split(/[/ :]/);

// Extract the day, month, year, hour, and minute components
var day = dateComponents[0];
var month = dateComponents[1] - 1; // Month is zero-based in JavaScript Date object
var year = dateComponents[2];
var hour = dateComponents[3];
var minute = dateComponents[4];
var period = dateComponents[5]; // AM or PM

// Adjust the hour based on the period (AM/PM)
if (period === "PM" && hour < 12) {
  hour = parseInt(hour, 10) + 12;
}

// Create a new Date object using the extracted components
var date = new Date(year, month, day, hour, minute);

// Format the date as "yyyy-mm-ddThh:mm"
var formattedDate = date.toISOString().slice(0, 16);

console.log(formattedDate);