Perhaps you should have a look at the function CALCDATE. For example CALCDATE('<-CW>',TODAY) would return the date of Monday in the current week. The parameter TODAY can be exchanged with any other date to get the date of Monday in that particular week.
Comments
From NAV Help:
DWY2DATE (Date)
Use this function to return a Date based on a weekday, a week, and a year
Salut!
Author of the book Implementing Dynamics NAV 2013
Cursos Dynamics NAV (spanish) : http://clipdynamics.com/ - A new lesson released every day.
If that's the case I would use the Date table to find out.
Never stop learning
Van Vugt's dynamiXs
Dutch Dynamics Community
Try this
Salut!
Author of the book Implementing Dynamics NAV 2013
Cursos Dynamics NAV (spanish) : http://clipdynamics.com/ - A new lesson released every day.