7 Replies Latest reply: Aug 8, 2016 4:50 PM by Stefan Wühl RSS

    This Week and Last Week

    Satish Kurra

      Hi

       

      I'm currently using the below boolean functions to get This Week and Last Week.

       

      -InWeekToDate(Date,Today(),0) as CurrentWeek,

      -InWeekToDate(Date,Today(),-1) as PreviousWeek,

       

      For Current Week, it is showing Date as 08/08 and 08/07

       

      and

       

      For Last week, it is showing Date as 07/31 and 08/01.

       

      I want to show Current Week from 08/07  - 08/13

      and in the similar way Last week as well.

       

      Can Someone help me in achieving this.

       

      Besides this for Date Range Calculation i would like to use flag

       

      For example, From Aug 1 - Aug 31 (full month Estimation using Flags)

       

      I do not want Max(Date) as i have Dates after Aug 31 2016 as well

       

      I need from Aug 1 2016 and Aug 31 2016 logic using Flags

       

      Thanks

      Satish