If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Concatenate dates per week

Started by omega1983, 10 Jun 2016 10:59:34 AM

Previous topic - Next topic

omega1983

cast([MinLockExpirationDate],varchar(20))+'-'+cast([MaxLockExpirationDate],varchar(20))
This formula will give the min and max date for the entire report.  Is there a way to accomplish this and segment by a week
For example  minimum([LOCK EXPIRATION DATE] for Report) and maximum([LOCK EXPIRATION DATE] for Report) provide me the beginning and ending dates for the entire report and not segmenting by say a 1 week period.

The entire date range is between _add_days(current_date,1) and _add_days(current_date,60)  however I want the concatenate to show per week
2016-06-06 -  2016-0610
etc
2016-08-01 - 2016-08-05

Instead I am getting
2016-06-06 - 2016-08-05