cancel
Showing results for 
Search instead for 
Did you mean: 

Filter Collection - Latest created date

TeutaPajaziti
Level 2

24353.png
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
------------------------------
2 REPLIES 2

LakshmiNarayan3
Level 6

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
------------------------------

Hello @TeutaPajaziti 

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

Adding the snaps here.

24350.png

Coll1-Input
Coll2-Output24351.png
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
------------------------------