Filter by specific day

Hello, I’m making the following flow with the following logic using date formatting. I’d like certain data to pass through if it’s different than Saturday and Sunday, does anyone have any ideas on how to do this?

This scenario consists of two applications only (very basic) google sheets and deleting data from google sheets, and I would like these data when different from Saturday and Sunday they delete but if it is the same do not delete

Hi @Marketing_Softexpert,

You can make use of the “formatDate” function available under “Date & time functions”.

If you use ‘d’ as the format, it will return a value between 0 and 6, where 0 represents the first day of the week (Sunday) and 6 represents the last day of the week (Saturday).

Example snippet: {{formatDate(now; "d")}}

You can use this function to determine if the current day is different from Saturday and Sunday, and then delete the data accordingly.

Glenn - Callinetic


Thank you, this is what I expected!

1 Like