Forum Discussion
Solved
Week 0
Hi, I have appointments data with a column for exact date and a column with "week commencing on..." (i.e. Monday date for that week). What I am hoping to achieve is an extra column that will say ...
you can modify the column as
WeekCommencingOn = var recentmaxdate = max(appDate) returns WeekNum(apptDate,1) - WeekNum(recentmaxdate ,1)
Yes, thanks!