Forum Discussion
powerlight1
Helper I
Helper ICreate Week Start date column within a date table
Hi community, I have a table with a date column and I am trying to create a new column that is Week_Starting (Monday). I have already created the Week Num and Day of Week columns and I wanted to...
Hi,
If your DATE_LYSLS is continuous and there is no missing date, try this for a new column
WeekStart = [DATE_LYSLS] - (WEEKDAY([DATE_LYSLS], 2) - 1)
MasonMA
Super User
Super UserHi,
If your DATE_LYSLS is continuous and there is no missing date, try this for a new column
WeekStart = [DATE_LYSLS] - (WEEKDAY([DATE_LYSLS], 2) - 1)
powerlight1Helper I
Helper Ilove the solution, so simple