Condition Date is within This Week

[rvigneau]

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".

[v-litu-msft · Accepted solution]

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:

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.