Hi
I have a sharepoint list which i wan to filter based on a date column. I onyl want items where the date is less than 7 days from todays date.
I have created a var which is todays date - 7 days
addDays(utcNow(),-7,'yyyy-MM-dd')
I then filter using this var with
DateofUKPost Le 'Var'
But whenever i run it i receive the error The expression "DateofUKPost Le '2021-01-26'" is not valid. Creating query failed.
any ideas as to what im doing wrong