How can I use same calender object for 2 different dates.
I have to provide user to select date type of his choice. If user selects Birthdate then table should get the values where Employees date of birth < selected date. If user selects the joining date then table should have values where employee joining date < selected date.
Basically what I require is same calender object for two diferent dates with Expressions usage.
It's far easier to use two calendar objects and show/hide them as needed. If you want to do things the hard way create an inline table:
load * inline [
date of birth
Then add a listbox for DateField. Select one value and the enable the option Always One Selected Value. In then calendar object you can now use an expression =[$(=DateField)] instead of a fixed date field.