how to get docs after specific date time?

Question

I want to get documents from a collection after a specific date time.

Example:

if the date = 30/11/2020, 12:30AM (in javascript)

The query should return documents created after the above date.
The query should not return documents created before the above date.

You can see my current code:

await db
    .collection(`users/${user}/messages`)
    .orderBy("cDate", "desc") /* {cDate: firestore.Timestamp.fromDate(new Date())}*/
    .limit(100)
    .get();

Any help

It's not really clear what you're trying to do here, since we can't see the data in your documents. But you will need to use a where clause to filter the documents in the query according to your needs. If you need help with this, you should edit the question to explain in more detail the actual contents of your documents, and what you've tried to do to filter them, as you see in the documentation: firebase.google.com/docs/firestore/query-data/… — Doug Stevenson
– Doug Stevenson, Commented Nov 30, 2020 at 19:12
@DougStevenson, I think it is clear, I just want to return documents after a specific date. exampe: after 30/11/2020 12:00AM. So my query should return all docs if they are created after this date and should not return those documents after before this date — Muhammad
– Muhammad, Commented Nov 30, 2020 at 19:18

Andres Gardiol · Accepted Answer · 2020-11-30 19:29:36Z

2

You can do something like this:

const isoDateTime = '2020-11-30T12:30:00';
await db
    .collection(`users/${user}/messages`)
    .where('cDate', '>=', isoDate);  //<--- Its important to have an ISO formatted date string
    .orderBy("cDate", "desc")
    .limit(100)
    .get();

With this you should get all the documents after the isoDate (included). You can use > to not include the date

answered Nov 30, 2020 at 19:29

Andres Gardiol

1,46717 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

11 Comments

Muhammad Over a year ago

thank you very much, and here is cDate is firestore date will it works ?

Andres Gardiol Over a year ago

In your firestore documents you should have an ISO DateTime string in your cDate properties

Muhammad Over a year ago

thank you, I will return back after checking your answer, if it works then will be accepted

Andres Gardiol Over a year ago

You can see more information about the where method here firebase.google.com/docs/firestore/query-data/…

Muhammad Over a year ago

Could you please let me know why ISO date is important ?

|

Doug Stevenson · Accepted Answer · 2020-11-30 19:56:43Z

1

If you're trying to filter the documents based on a timestamp type field, you can simply provide a JavaScript date object as a filter on that field.

.where("cDate", ">", aJavaScriptDateObject)

You can also use a Firestore Timestamp object as well.

answered Nov 30, 2020 at 19:56

Doug Stevenson

321k37 gold badges458 silver badges474 bronze badges

8 Comments

Muhammad Over a year ago

will it be supported by any date object ?

Muhammad Over a year ago

example: new Data().toISOString()

Doug Stevenson Over a year ago

No, that's a string, not a date object.

Muhammad Over a year ago

Is that possible to save in firestore as {cDate: new Date()}. if yes will still orderBy works ?

Doug Stevenson Over a year ago

That also saves a timestamp that can be ordered with other timestamps.

|

Collectives™ on Stack Overflow

how to get docs after specific date time?

2 Answers 2

11 Comments

8 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

11 Comments

8 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related