Calculated column with interval between start and end dates selected in prompt

Mohamed Hasan

Summary:

When i select the start and end dates in a prompt, i want to have a calculated column that shows the interval between the start and end dates, i want to use this calculated interval for another calculation. Any idea, how i can have this?

Content (required):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

Bhaskar Konar

Hi @Mohamed Hasan ,

You can try prompting the Start and End dates separately in your prompt. You can then create two presentation variables to receive each date.

Receiving those dates through Presentation variables will allow you to pass them to a report and get the Date Diff between them. Here is the column formula:

TIMESTAMPDIFF(SQL_TSI_DAY, @{pvStartDate}{CURRENT_DATE}, @{pvEndDate}{CURRENT_DATE})

Hope this help.

Cheers,