Week Range Idea
I'm trying to make a weekly report, and I want to have a dynamic drop down list for the weeks I have records on it. I know how to do that, but the text I want to see in that drop down list is the key in this post.
I'm using a field called "Date" that records the date when the transaction has made.
and field "WeekSort" as WeekOfYearFiscal (Date;2) number 2 because I want to start weeks on Monday
So, basically my idea that I need help for, is making a calculation field for the first and last record of WeekSort, extract his date and displays like "Week 6, from 02/02/2015 to 02/06/2015" (from monday to friday)
Is it possible?
Thank you all.