I have a report comparing performance between 2 different weeks.
I allow the 2 weeks to be selected in format YYYYww.
Once selected, I would like to display the date range for the week selected eg.
2015 04 would have the range 25Jan2015 - 31Jan2015.
Any neat ideas how to do this ?
= WeekStart(DateField) & ' - ' & WeekEnd(DateField)
Are these weeks normal calender weeks - if so above comment should work
I felt sure someone would have a neat solution - I just need to sort out the formatting of DateField and it will be ideal.
Retrieving data ...