25-09-24 11:23 AM
Hello all,
I am currently trying to make a filter for a collection which has a "Date" collumn, and my aim is to get all items for which that date is between the first and 15th of any month and any year. To that end, I assumed that I could use the < and > operands, but I cannot figure out how to get the value specific to the day, and I would like to avoid using a hardcoded value such as "Date LIKE '01/*' OR Date LIKE '02/*'" all the way to 15.
Is there some expression to get the date's day value and turn it into a number which can be compared directly within the action's filter field ?
Thank you in advance for your returns !
Bastien
27-09-24 02:08 AM
Because you, from your examples, have zero padding in your date format it is fairly easy to apply a filter to pull out the rows you want.
You just have to create a filter string that:
"Substring(Convert([Date Column], System.String), 1, 2)<16"