The community of Analytics developers are invited to follow and participate in the developer network.
OpenText technical experts collaborate with supported customers and partners in the Magellan product area.

Set different day as start and end of the week in BIRT Report

Hi All,
Generally Monday is considered as start of the week and Sunday is considered as the end of week. I would like to understand whether there is a way to change this to start of the week = Wednesday and end of the week = Tuesday . User would be entering start date and end date as report parameter which would be typically for a month. For example 
start date = 04/01/2020 and end date = 04/30/2020 , below is the data present in the table and the output should be like second table 

I have been trying to do this using DB2 query however it doesnt seem to be achievable hence wanted to know if there is a way to achieve this using BIRT. 


column1 column2 Week
abc  64 1
abc  2 2
abc  50 3
abc  23 4
abc  22 5
Tagged:

Comments

  • edited May 26
    Getting the week of the month with the week starting on Wednesday is possible in BIRT. 
    Create a computed column in the data set.  In the expression builder for the column, use the BirtDateTime functions.  The weekOfMonth method gets the standard week count.  I think you will need to get the day of week for the first day of the month.  If it is >= 4, then subtract 1 from the weekOfMonth only if the dayOfWeek is < 4, else add 1 to the weekOfMonth only if the dayOfWeek is >= 4. 
    Please test this logic carefully.
    Regards,
    Jeff F.
    Sr. Technical Support Specialist
    OpenText
Sign In or Register to comment.