Dates in a week

[richard_chilvers]

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 ?

Thanks

Richard

[Colin-Albert · Accepted solution]

Try

= WeekStart(DateField) & ' - ' & WeekEnd(DateField)

[Anonymous]

Are these weeks normal calender weeks - if so above comment should work

[richard_chilvers]

Thanks.

I felt sure someone would have a neat solution - I just need to sort out the formatting of DateField and it will be ideal.

Richard