I have one filed Date1 consisting the date. Now using the Calender(2 Object) one for From Date and another for To Date. Whenever i select the From Date to Todate the Date1 should reflect the selection between the Dates. But i need it without using themacro. Please send me the settings if any.