HI.
I have a main form which stores two dates to session variables.(A from and to date)
(I convert them to strings as I was having difficulty just storing the dates as session variables)
When I use them in the called form, I invariably get a SQL exception error in my sql statement saying theres an error in converting date to strings..

Is there a 'correct way' to do this as most things I have tried with dates have taken hours of experimenting and seldom work.

A few specisic questions:
1. Can I strore a date in a session variable
2. How do I include these in a sql select
as in Select * from MyTable where DateFld >= sesFromDate and DateFld <= sesToDate

Any help appreciated.

Regards,
Gerard