4 Replies Latest reply on Feb 3, 2015 10:33 PM by AlejandroAlanis

    Week Range Idea

    AlejandroAlanis

      Title

      Week Range Idea

      Post

      Hi everyone,

      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.

      Alex