OTBI: Adding 2 dates (Effective Start Date) and (Effective End Date) to the Dashboard Prompt

Summary

OTBI: Adding 2 dates (Effective Start Date) and (Effective End Date) to the Dashboard Prompt

Content

Hi,

I have a scenario where I need to add 2 dates on to the dashboard prompt , one is Effective Start Date and another is Effective End Date.

In the dashboard I have 3 analysis. In first analysis I need to capture these dates and compare with it like enterprise hire date is in between the dates. In second analysis, I have to compare if termination date is in between the 2 dates. In third analysis, I have to compare if assignment start date of the employee is between effective start date and effective end date.