How can I Calculate The Difference between changing date field (Date1) & a specific day in the same week of the date by using DateDiff
For example:
-Date1 = 10/11/2005, Wednesday of that week is 10/12/2005
-Date1 = 10/24/2005, Wednesday of that week is 10/26/2005
The function calculate the difference= 1 in the 1st example, 2 in the 2nd example