You’re offline. This is a read only version of the page.
Announcements
Trying to get an automation that pulls rows from one Excel file only if that row's "DateSent" value is in the current week. So far I have it List rows present in a table, then I added a condition, but in the condition I can't seem to figure out how to write the formula to have it recognize "within this week".
Hi @rvigneau,
You could initialize two string variables to store the start day of current week and end day of current week:
Start Day of Week:
Share
Report
All responses (
Answers (
addDays(utcNow(),int(concat('-',dayOfWeek(utcNow()))),'yyyy-MM-dd')End Day of Current week:
addDays(utcNow(),sub(6,dayOfWeek(utcNow())),'yyyy-MM-dd')
Then create a condition check if a date is greater than or equals to start day of current week, and less than or equals to end day of current week:
Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
538
