Restrict the date field

[bhavvibudagam]

Hi,

I have a date field i.e ACCIDENT_DATE.In the date field i have the data from 2001 to 2016.

My requirement is when i click on 2006 then it has to be displayed back 5 years i.e from 2001 to 2006.

It has to be done in Dynamically in Script only.Please help me to do.If possible please attach the sample qvw file.

[bindu_apte]

Hi,

Hope this thread will help.

Dynamic Ytd from selection

[#3]

Hi Bhavvi,

try like below

ACCIDENT_DATE=<=$(max(ACCIDENT_DATE))

in your expression.

Regards

Tripati

[Kushal_Chawda]

try below expression

=Sum({<Year = {">=$(=max(Year)-5)<=$(=max(Year))"}, Year=>}Amount)

[Digvijay_Singh · Accepted solution]

Check this example, just removed 'Year=' from what Kushal has suggested

[Digvijay_Singh]

Also not sure why you would want this to be done in script, you may need to you asoftable concept along with flag creation to identify 5 years window in the front end.

[bhavvibudagam]

Thank you so much Digvijay for the above attachment file. Can you please upload the Sample Qvw file with flag creation.