Hi, i'm looking to delete row in a spreadsheet if it more than 30 days old. This is what I have so far.
Compose 2 is addDays('1899-12-30',int(outputs('Compose')),'dd-MM-yyyy')
Condition is output of compose 2 'equal to' addDays(utcNow(),-30)
even though I have rows that would qualify the condition result is False.
Grateful for help.
Solved! Go to Solution.
Solved myself, just changed Is 'equal to' to is 'less than or equal to'.
Solved myself, just changed Is 'equal to' to is 'less than or equal to'.
Hi beanybone
Thanks for sharing the solution.
Regards,
JAvier
User | Count |
---|---|
97 | |
40 | |
27 | |
23 | |
16 |
User | Count |
---|---|
130 | |
51 | |
48 | |
36 | |
24 |