How to Compare Dates in an Array of MongoDB Objects with Varied Date Formats

Question

How to Compare Dates in an Array of MongoDB Objects with Varied Date Formats

In the frontend, I am utilizing a datepicker that sends a date through an AJAX Request. The date is in the format 'YYYY-MM-DD'. I need to compare this date with dates in an array retrieved from a MongoDB collection. These dates include a Timezone and are formatted as follows: "2020-06-03T00:00:00.000Z"

Slot Json Object

{
  date: [
    2020-06-03T00:00:00.000Z,
    2020-06-05T00:00:00.000Z,
    2020-06-07T00:00:00.000Z
  ],
  __v: 0
}

I have to iterate over each date in the array and compare it with the date from the frontend.

Assuming the user input date is

let userInput = '2020-06-03';

I need to ensure that comparing '2020-06-03' with '2020-06-03T00:00:00.000Z' returns true. How can I achieve this comparison while looping through all elements in the array?

javascript arrays datepicker momentjs

Answer 1

Answer №1

When your date array is always set to 00:00:00, I would recommend using this approach:

const dates = [
  '2020-07-12T00:00:00.000Z',
  '2020-07-15T00:00:00.000Z',
  '2020-07-18T00:00:00.000Z'
];

let userInput = '2020-07-15';

function searchDates(date) {
  const searchDate = Date.parse(date);
  const foundDates = [];

  dates.forEach(date => {
    const tempDate = Date.parse(date);

    if (tempDate === searchDate) {
      foundDates.push(date);
    }
  });

  return foundDates;
}

console.log(searchDates(userInput));

If there are other factors to take into consideration, please let me know.

Answer 2

When your date array is always set to 00:00:00, I would recommend using this approach:

const dates = [
  '2020-07-12T00:00:00.000Z',
  '2020-07-15T00:00:00.000Z',
  '2020-07-18T00:00:00.000Z'
];

let userInput = '2020-07-15';

function searchDates(date) {
  const searchDate = Date.parse(date);
  const foundDates = [];

  dates.forEach(date => {
    const tempDate = Date.parse(date);

    if (tempDate === searchDate) {
      foundDates.push(date);
    }
  });

  return foundDates;
}

console.log(searchDates(userInput));

If there are other factors to take into consideration, please let me know.

Answer 3

Answer №2

Ensure that the date strings in the input and the array of dates are correctly formatted for parsing. Then, you can simply utilize the isSame() function to determine if the dates are identical

let input = "2020-06-03";
let arr = [
  "2020-06-03T00:00:00.000Z",
  "2020-06-05T00:00:00.000Z",
  "2020-06-07T00:00:00.000Z"
];
let result = arr.map(item =>
  moment(item, "YYYY-MM-DD hh:mm:ss zz").isSame(input, "YYYY-MM-DD")
);
console.log(result);

<script src="https://momentjs.com/downloads/moment.js"></script>

Answer 4

Ensure that the date strings in the input and the array of dates are correctly formatted for parsing. Then, you can simply utilize the isSame() function to determine if the dates are identical

let input = "2020-06-03";
let arr = [
  "2020-06-03T00:00:00.000Z",
  "2020-06-05T00:00:00.000Z",
  "2020-06-07T00:00:00.000Z"
];
let result = arr.map(item =>
  moment(item, "YYYY-MM-DD hh:mm:ss zz").isSame(input, "YYYY-MM-DD")
);
console.log(result);

<script src="https://momentjs.com/downloads/moment.js"></script>

How to Compare Dates in an Array of MongoDB Objects with Varied Date Formats

Answer №1

Answer №2

Similar questions

The EJS template on the Express app is encountering an issue: it is unable to find the view "/id" within the views directory located at "/home/USER/Desktop/scholarship-app/views"

Change the structure of the content in a div

A guide to transporting an item from coordinates {x,y} to {newx,newy} using Three.js

Customizing the appearance of Previous and Next elements using JavaScript

Tips for transferring data from an HTML textbox to a JavaScript variable

Using jQuery to send emails

What steps can be taken to prevent a child component from re-rendering when the parent updates the context or state in React JS?

Avoid binding an object in Vue.js when you intend to copy it to a different data attribute

When implementing jQuery AJAX, remember to properly encode script tags to prevent any

UI Select not found result event

Using Typescript to pass inferred type to React's useCallback

How can you create a MUI textfield that only allows numerical values to be entered in the password field?

How can I customize button colors in react-bootstrap components?

Arrange 3D blocks on a grid using ThreeJS with customizable dimensions

determine the height of a div using jquery calculations

Sending a message to an iframe from a different origin using JavaScript

retrieving data from Redis with the help of Node.js

Error in Winston: Unable to determine the length of undefined property

How to open a new window in a separate desktop on macOS using Javascript

Establishing the Time-to-Live (TTL) with Redis-OM and Node Object Mapping