Calendar Scenario

[Anonymous]

Hi All,

I am having field called Activity_Date in DB. I need to use this date field (From Date/To Date)as a two separate calendar object.

As I having single field (Activity_Date) how to use in two different Calender Obj.

Thanks,

-Jay

[Anonymous]

Without seeing the DB structure it is impossible to guess what on earth you are trying to make do what.

[Anonymous]

Thank You Bill

[djsampat]

Hi,

Why dont you try making a MonthYear field like Month(ActivityDate)&Year(ActivityDate) as MonthYear and then you can select a range from 012014 to 122014 being Jan to Dec 2014.

or

.

See this blog post for the answer: Creating Reference Dates for Intervals

or

I prefer to use 2 seperate variables. one for Start Date and another for End Date and Do the comparison of the dates in the expressions using set analysis

Sum({<selected_date={'>= $(vStartDate) <=$(vEndDate)'}>}Measurename)

If this helped you, please mark as Helpful. If it solves your issue, please mark as Answer

Regards

Dhruv

[Anonymous · Accepted solution]

Hi All,

  I was ref and able to find out the way to achieve the same. Kindly have a look and let me know any other optios

-Jay