Hi All,
As per requirement I have applied max of effective date for each customer. I am using SQL server2008 and in the database effective date is datetime format. I have converted that column in report using ‘Format Field’ and report working fine.
When I export the report and view from server dates are not coming properly.
ex: 04/15/2012 coming as 04/15/1905
sreeks (BOB member since 2008-07-14)