Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
???????
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
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)))
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
yes,and u can also use these variables in set analysis if u need too.
regards
Thanks Vlad, it works fine.
Thanks layal.
No problem, please verify correct answers
i checked the answers