topic RE: Filter Collection - Latest created date in Product Forum

Filter Collection - Latest created date

TeutaPajazitiMerovci — Mon, 22 May 2023 11:26:00 GMT

Hi,

I need to filter a collection using Created date, as you can see attached above.
I am trying filter "[Created] < '" & Now() & "'" also trying another filter "[Created] < ='" & [Date] & "'"
"[Created] > ='" & [Date] & "'" it is not working, it is not taking the latest file created, if you have any idea how to solve i would appreciate it, thankyou in advance

------------------------------
Teuta Pajaziti
------------------------------

RE: Filter Collection - Latest created date

plnarayana777 — Mon, 22 May 2023 12:51:00 GMT

if your requirement is to get the last created file then you sort the collection in descending and get the first row data

Regards

------------------------------
Lakshmi Narayana
------------------------------

RE: Filter Collection - Latest created date

Tejaskumar_Darji — Tue, 23 May 2023 04:08:00 GMT

Hello @TeutaPajazitiMerovci

I tried to replicate the same and it is working for me - "[Created]<'"&Now()&"'"

Adding the snaps here.

Coll1-Input
Coll2-Output
Are you getting any errors?

Also as suggested above sort option would also work fine as the datatype is DateTime.

Let us know how it goes for you

------------------------------
If I was of assistance, please vote for it to be the "Best Answer".

Thanks & Regards,
Tejaskumar Darji
Sr. Consultant-Technical Lead
------------------------------