I have the following error being displayed on a client site when I try to do a search with either of "Find a Certificate" or Find a Smart Card" Bei der Konvertierung eines varchar-Datentyps in einen datetime-Datentyp liegt der Wert außerhalb des gültigen Bereichs Which translates to The conversion of a varchar data type to a datetime data type of the value is out of range Any ideas, this all works in my own environment

On Thu, 3 Nov 2011 15:25:41 +0000, DarrenBonehill wrote: I have the following error being displayed on a client site when I try to do a search with either of "Find a Certificate" or Find a Smart Card" ? Bei der Konvertierung eines varchar-Datentyps in einen datetime-Datentyp liegt der Wert au?erhalb des g?ltigen Bereichs Which translates to ? The conversion of avarchar data type to a datetime data type of the value is out of range ? Any ideas, this all works in my own environment Try restricting the date range for your search to a range where both the day and the month are 12 or less. This sounds like it might be a localization issue where the US date format is being used for the range against a server that isn't using the US date range which could well result in the month being greater than 12. Paul Adare MVP - Identity Lifecycle Manager http://www.identit.ca Code: Virus lasting about three to five days, accompanied by sore throat, runny nose and fever.

Interestingly when I enter date information everything seems to function, what I did notice though was that that in the Search Result Format the Serial Number was unselectable and in the client site hadn't giot it checked. In my environment this setting is selected even thpough still greyed out. I'm wondering if this is the initial problem but why is it like this and where do I check for this setting. I'll do some more investigations. Darren