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);
});
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