22-05-23 12:26 PM
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
22-05-23 01:51 PM
if your requirement is to get the last created file then you sort the collection in descending and get the first row data
Regards
23-05-23 05:08 AM
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