Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Lastfullweek

Morning all,

I am using Last Full Week function in my formula to calculate information for last week however that runs from Sunday to Saturday, instead I would like to run it from Monday to Friday.

Is there any possibility I can do this using Lastfullweek function?

I have tried looking into a help file but it doesn't show any help on this issue.

(Do I have create a formula to make it work?)

Regards

Jehanzeb

Former Member
replied

Hi,

I guess you are using LastFullWeek function as follows

If {Your date field} in LastFullWeek then u201CYesu201D else u201Cnou201D.

Here LastFullWeek function calculates from last Sunday to Saturday.

To get the results form last Monday to Friday using LastFullWeek function write the formula like this.

If {your date field} in minimum(LastFullWeek)+1 to Maximum(LastFullWeek)-1 then u201CYesu201D else u201CNou201D;

I think this will be helpful.

Regards.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question