Jul 11, 2020 at 04:27 AM

How to Find Fortnight date between two date in web intelligence report

176 Views

Hi,

I am new to Webi reports. I have a requirement to find a fortnight date between two dates and display feature dates as per the fortnight date.

For example:- in each month, 14th and 28 date is a fortnight date. I need to achieve below logic in webi reports formula calculation.

If(date = 06/28/2020) -- "MM/DD/YYYY"

need to display this date as a report date (we have a one-column cell and named as report date in webi reports) for every day report running till 07/14/2020.

also display all the feature dates in webi report table columns like below

06/29/2020 - "MM/DD/YYYY"

06/30/2020 - "MM-DD-YYYY" So on... till 07/14/2020

if(date = 07/14/2020) -- "MM/DD/YYYY"

need to display this date as a report date (we have a one-column cell and named as report date in webi reports) for every day till 07/28/2020.

also display all the feature dates in webi report table columns like below

07/15/2020 - ("MM/DD/YYYY" format)

07/16/2020 - ("MM-DD-YYYY") So on... till 07/28/2020

How to achieve this by using webi report functions?

Can any one help me on this?

Thanks in advance.