How to query date range (between)?

[tgmarinho]

const start = new Date('2022-01-01');
const end = new Date('2022-01-31');

const eventsRef = db.collection('events');

const query = eventsRef
  .where('startDate', '>=', start)
  .where('startDate', '<=', end)
  .orderBy('startDate');

query.get()
  .then(querySnapshot => {
    querySnapshot.forEach(doc => {
      console.log(doc.id, '=>', doc.data());
    });
  })
  .catch(error => {
    console.error(error);
  });

// other sample
const date1 = new Date('2023-12-31T00:00:00.000z');
firestore.collection(COLLECTIONS.ORDERS).where('dateformatted', '<=', date1)

const date2 = new Date('2023-12-31T00:00:00.000z');
firestore.collection(COLLECTIONS.ORDERS).where('dateformatted', '<=', firebase.firestore.Timestamp.fromDate(date2))

field dateformatted is Timestamp

Why this doesn't work?

[ryanmio]

Your issue may be due to type inconsistency or missing index. Since your field dateformatted is a Timestamp, make sure to query using Firestore's Timestamp.

Here's how you can query:

const date1 = firebase.firestore.Timestamp.fromDate(new Date('2023-12-31T00:00:00.000z'));

firestore.collection(COLLECTIONS.ORDERS)
  .where('dateformatted', '<=', date1)
  .get()
  .then(querySnapshot => {
    querySnapshot.forEach(doc => {
      console.log(doc.id, '=>', doc.data());
    });
  })
  .catch(error => {
    console.error(error);
  });

Make sure you have an index for the 'dateformatted' field. If the problem persists, debug by printing the error message.

Hope this helps!