Forum Discussion

Dev-13's avatar
Dev-13
Icon for Helper I rankHelper I
3 years ago
Solved

Population of dates between dates

Hi    I have a week start and a week end date. I have days of the week but no date is assigned to them. I would like a date assigned to the actual day that falls inbewteen the week start and end da...
data protection
  • rsbin's avatar
    rsbin
    3 years ago

    Dev-13 ,

    Easiest way is create a Calculated Column:

    Date = SWITCH(
           TRUE(),
           [Day of Week] = "Monday", DayofWeek[Week Start] + 1,
           [Day of Week] = "Tuesday", DayofWeek[Week Start] + 2,
           [Day of Week] = "Wednesday", DayofWeek[Week Start] + 3,
           [Day of Week] = "Thursday", DayofWeek[Week Start] + 4,
            [Day of Week] = "Friday", DayofWeek[Week Start] + 5,
             [Day of Week] = "Saturday", DayofWeek[Week Start] + 6 )

    Trust this helps.

    Regards,

rsbin's avatar
rsbin
Icon for Community Champion rankCommunity Champion
3 years ago

Dev-13 ,

Easiest way is create a Calculated Column:

Date = SWITCH(
           TRUE(),
           [Day of Week] = "Monday", DayofWeek[Week Start] + 1,
           [Day of Week] = "Tuesday", DayofWeek[Week Start] + 2,
           [Day of Week] = "Wednesday", DayofWeek[Week Start] + 3,
           [Day of Week] = "Thursday", DayofWeek[Week Start] + 4,
            [Day of Week] = "Friday", DayofWeek[Week Start] + 5,
             [Day of Week] = "Saturday", DayofWeek[Week Start] + 6 )

Trust this helps.

Regards,