Which function should I use when I want to know which name of day a date is (Monday, Theusday...? For example I use the following script to create rolling week data:
DATE# (MID(Date,3,2)& '-' &Week(MakeDate(Mid(Date,1,4),Mid(Date,5,2),Mid(Date,7,2))),'YY-WW') as [ROLLING WEEK]
