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
You can make use of the “formatDate” function available under “Date & time functions”. https://www.make.com/en/help/functions/date---time-functions#formatdate--date--format---timezone--
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). https://www.make.com/en/help/functions/tokens-for-date-time-formatting#year--month--and-day-tokens-935202
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!