Gerard,
Use parameters.
Cetin
>Hi Kevin.
>Tried that and it works..up to a point.
>I have got the Session varaibales stored as date fields now ok int the Called form, but cannot get the select to work:
>Keep getting a :-
>Conversion failed when converting datetime from character string
>
>x="Select * from MyTable where MyDate" + " >= " + ?????? ldDate
>I am unsure what syntax to use with the date
>Do I need to convert the ldDate to a string ?
>
>
>regards,
>Gerard
>
>
>
>
>>Hi, Gerard,
>>
>>You should be able to store datetime values in Session Variables.
>>
>>
>>DateTime dtToday = DateTime.Today;
>>Session["SessDate"] = dtToday;
>>
>>DateTime dt2 = (DateTime)Session["SessDate"];
>>
>>
>>I'd recommend passing them as parameters to a data access layer.
>>
>>Hope that helps...
>>Kevin