How to fix Start Date and End date of the projects based on year filter

[gurusai sankar]

Hi All,

i have the data as i mentined in the below.

Proj No , Proj Name , Proj Start Dt, Proj End Dt.

I need to show the all projects based on the year selection in the filte and satsfy all below conditions. there should be only one year filter.

conditions:

The projects selected should be based on

- all projects whose start date is within the years selected

- all projects whose end date is within the years selected

- all projects whose start date is less that the year and end date is greater than the year

 

i have attched sample dxp. kindly help me on this.

Regards,

Guru sankar

[James Watts]

Create a document property as an integer, and a drop down list with values from 2017 to 2025. Let's call it "usrYear".

Add a data expression to limit the displayed data, based on the result of :

Year([Proj Start Dt])< (${usrYear}+1)

And

Year([Proj End Dt])>= ${usrYear}

(You only want projects that start before the end of the year, and finished after the start of the year).

[gurusai sankar]

Thanks a lot for your help Jim. It worked. 

 

Regards,

 

Guru Sankar