Converting string to a datetime

[CrazyManiac]

Hi all!
I'm using CR9 and MS SQL Server. My report has two string parameter fields {?DateBegin}
and {?DateEnd}. Parametrs are passed as strings with default format("dd.mm.yyyy hh:mm:ss"). When parameters are passed to a report I try to convert them to datetime (datetime function) and to pass to SQL server. But if in the regional settings the default date format "dd/mm/yyyy hh:mm:ss PM",
an error occurs "Bad date format string". How can I convert a stirng to a datetime with predifend format?
Thanks for help!

 

[BurnsORegan]

Why not use Date:time format for the parameters, then no conversion is required?

BurnsORegan

 

[SQLBill]

There must be something else wrong...I ran a query on my SQL Server and it converted the 03.09.2004 12:00:00 to DATETIME just fine.

Do you verify that the parameters are actually valid dates and times?

-SQLBill

 

[CrazyManiac]

2 SQLBill:
and what is your system datetime format? This error occurs when system datetime format differs from "dd.mm.yyyy hh:mm:ss

 

[SQLBill]

Mine is dd/mm/yyyy

-SQLBill