Kind Of between function using DATES

[Anonymous]

Hi Every one,

i'm looking to find womething to help me to get a range of dates.

for exepmle i want the dates between admonths(MyDate,-12) and addmonths(MyDate,-7)

???????

[#2]

try this ,

=(MakeDate(Year(date(MonthName(PeriodDate,-12))),Month(date(MonthName(PeriodDate,-12))),Day(PeriodDate)))

=(MakeDate(Year(date(MonthName(PeriodDate,-7))),Month(date(MonthName(PeriodDate,-7))),Day(PeriodDate)))

[vgutkovsky · Accepted solution]

You mean to dynamically generate a list of dates after a user selects something in "MyDate"? Assuming MyDate is a variable, you can create a trigger (activated, for example, on a button click, although you can also activate it through Document Properties >> Triggers on a Variable Event trigger). See attached for a very simple example.

Regards,

Vlad

[#4]

yes,and u can also use these variables in set analysis if u need too.

regards

[Anonymous]

Thanks Vlad, it works fine.

Thanks layal.

[vgutkovsky]

No problem, please verify correct answers

[Anonymous]

i checked the answers