Guess I didn't explain my query properly. The Crystal Report is called from VB and is based on a SQL Server stored procedure that has a datetime input parameter. In Crystal Report 5 when we pass the date from the front-end (VB) or even in Crystal Report if we say database - stored procedure parameters ( I think that is the option), then it wants the date in the format - yyyy.mm.dd 00.00.00.000. But this format does not work in Crystal Report 7 - so what is the new format or is the old format OK and we need to do something else?
[sig][/sig]
[sig][/sig]