Forum Discussion
Date column Convert new column Week basics
I am trying to Create a new column called week based on below logic If day part of lead_date <=7 -> Wk1 If day part of lead_date between 8 to 14 -> Wk2 If day part of lead_date between 15 to 21...
Hi!
You can try create calc column
SWITHC(TRUE(),
DAY([lead_date]) <= 7, "Week 1",
DAY([lead_date]) <= 14, "Week 2",
DAY([lead_date]) <= 21, "Week 3",
"Week 4"
)
technolog
Super User
Super UserHi!
You can try create calc column
SWITHC(TRUE(),
DAY([lead_date]) <= 7, "Week 1",
DAY([lead_date]) <= 14, "Week 2",
DAY([lead_date]) <= 21, "Week 3",
"Week 4"
)