Skip to Content
avatar image
Former Member

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Sep 01, 2008 at 11:35 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Aditya!

      You have made my day.

      I was working along the the similar lines but it wasn't passed my head that I should be using +1 and -1.

      Many thanks

      10 Stars!!!

      Regards

      Jehanzeb