Forum Discussion

joschultz's avatar
joschultz
Advocate II
8 years ago
Solved

Dynamic week end date

    Looking for a way to create a calculated column that will change the week ending date starting with Yesterday.  So for instance   Date Week End 9/2/2017 9/2/2017 9/1/2017 9/2/2017...
Need Help
  • DSP's avatar
    DSP
    8 years ago

    Lots of suggestions here

  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi joschultz,

     

    I'd like to share a simple formula to get current week end date.(based on your data, it seems like saturday?)

    Calculate column formula:

    Week End = [Date]+ 7-WEEKDAY([Date],1)

     

    Notice: weekday will get day of week.(1~7, 1= sunday, 7 saturday), if you want modify the week end date, you only need to modify '7' to which you wanted.

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Joseph,

 

Please calrify.

 

a) How is this table populated ?

b) Is this a Calendar Table that gets dynamically populated with starting date as (????????) and ending date as today ?

 

Let me know then I can try to work out a solution for you.

 

Cheers

 

CheenuSing