How to Subtract 1 week from current iso week

(0) Share

Report

Posted on by hcsharma19

Hi All,

I have a query about showing last week in Power Automate from current week.

I got current iso week by using expression(

div(add(dayofyear(addDays(subtractFromTime(utcNow(), if(equals(dayofweek(utcNow()),0),1,sub(dayofweek(utcNow()),6)), 'Day'),3)),6),7)).

this is for WK 05 2023 and want to show WK04.

can anyone help me with the steps and expressions.

Categories:

All responses (5)

Answers (2)

Sort by

ScottShearer 25,331 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@hcsharma19

Try this:

div(dayOfYear(utcNow()),7)

You'll find a similar solution here
hcsharma19 24 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello Scott,
Thanks for the update.
However, this will only give me the current week.
my requirement is to add the last week(i.e, we are in ISOWK 05 2023, but want to add WK04 2023).
Verified answer

ScottShearer 25,331 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

@hcsharma19

I did not appreciate that you want ISO week (although you said that...).

Why not just use and add() expression:

add(div(add(dayofyear(addDays(subtractFromTime(utcNow(), if(equals(dayofweek(utcNow()),0),1,sub(dayofweek(utcNow()),6)), 'Day'),3)),6),7)),-1)
hcsharma19 24 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello Scott, it worked Thanks.
Can you help me with expression for showing last month(i.e we are in Feb-2023 and want to show Jan-2023 in mail body).
Also, how to show only ISO year.
Thanks
Verified answer

Chriddle 8,729 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Last month:
addDays(startOfMonth(utcNow()), -1, 'MMM-yyyy')

Current year:
formatDateTime(utcNow(), 'yyyy')