How to get values between two dates using Set Analysis

[Anonymous]

Hi

In my report I have a STOCKDATE field and a STOCKVALUE field - I want to get the value (STOCKVALUE) based on the date in the last 12 months from todays date, stock over 1year old, stock over 2 years old etc. How can I do this?

[isingh30]

Try this -

only({<STOCKDATE = {'date,---'}>}STOCKVALUE)

Thank you!

[Chanty4u · Accepted solution]

try this

create two variables to read the start and end date,

then try like this:

count({<Calender_Date={">=$(=Date(vStartDate,'MM/DD/YYYY'))<=$(=Date(vEndDate,'MM/DD/YYYY'))"}>}Dimension)

Note: All date format should be same.

[Digvijay_Singh]

Something like this -

Sum({<STOCKDATE = {"<=$(=today())>=$(=addmonths(today(),-12))"}>}STOCKVALUE)

[Anonymous]

I have created two variables vStartDate (=Min(STOCKDATE) and vEndDate =Max(STOCKDATE) and then the formula i used was:

SUM({<STOCKDATE={">=$(=Date(vStartDate,'MM/DD/YYYY'))<=$(=Date(vEndDate,'MM/DD/YYYY'))"}>}STOCKVALUE)

I get 0... not sure why? what have i done wrong?

[Anonymous]

my STOCKDATE field is a datetime field if that makes a difference?

[Anonymous]

Using Sum({<STOCKDATE1={"<=$(=today())>=$(=addmonths(today(),-12))"}>}STOCKVALUE) I get zero as well

[Anonymous]

I amended my data import to convert the datetime field into just a date field and it works! Thankyou very much for your help!!