Converting string date datatype to date datatype

[syedmca]

Hi,

In select expert i need to put condition that database field which is of string dataypt >= date data type .

How can i do this plz explain me step by step



Thanks
Syed

 

[lbass]

You would have to show us how the string date displays. Be sure to tell us how it is formatted, e.g., MM/dd/yyyy or dd/MM/yy, etc.

-LB

 

[syedmca]

Hi,

String which is a database field is yyyy-mm-dd hh24:mi:ss
is to be compared against a parameter(date) datatype.


In select expert it is showing error statign that for database field expecting datetime
Plz help me in this regard.Step by step

 

[lbass]

You should be able to create a formula like this:

cdate({table.yourstring})

... and then set the formula equal to the date parameter.

-LB