Business
Jobs
  • About Us
  • Solutions
    • Job Postings
      Post your job and receive qualified candidates in 48h.
    • Candidate Assessments
      500+ technical and psychological tests, plus anti-fraud.
    • Headhunting
      Tailor-made executive search from start to finish.
    • Payroll + EOR
      Payroll dispersal and EOR across 15+ LATAM countries.
  • Pricing
  • Jobs

0

291
Views
how to query docs in firestore based on the date you chose in firestore V9

i want to fetch the docs based on a date im inputing , and these docs have their timestamp in docs data , i tried querying with where() but still not working or maybe im not doing in the right way

im getting the date from this library



  const showDatePicker = () => {
    setDatePickerVisibility(true);
  };

  const hideDatePicker = () => {
    setDatePickerVisibility(false);
  };

  const handleConfirm = (date) => {
    setDate(date);
    hideDatePicker();
  };
 <Button title="Show Date Picker" onPress={showDatePicker} />
      <DateTimePickerModal
        isVisible={isDatePickerVisible}
        mode="date"
        onConfirm={handleConfirm}
        onCancel={hideDatePicker}
      />

And this is my query

  const finishedRef = collection(db, "validatedOrders");
     const finishedQ = query(
       finishedRef,
       where("status", "==", "Delivered"),
       where("date", "==")
     );
const finishedSnapshot = await getDocs(finishedQ);
     finishedSnapshot.forEach((doc) => {
       finished.push(doc.id);
     });


about 4 years ago · Juan Pablo Isaza
1 answers
Answer question

0

If the date fields in your database have Timestamp values, you'll need to use add both >= and < conditions on that field for the range of timestamps for the date values you want returns.

See for an example of this: Firestore Cloud Function query by DATE and Firestore query by date range

about 4 years ago · Juan Pablo Isaza Report
Answer question
Find remote jobs

Discover the new way to find a job!

Top jobs
Top job categories
Business
Post vacancy Pricing Sales
Legal
Terms and conditions Privacy policy
© 2026 PeakU Inc. All Rights Reserved.
Andres GPT
Show me some job opportunities
There's an error!