More on dates

Put your SqlExecute('Select.....' inside the parentheses of SQLDateTimeToDateTime( ). 

form1.DateTimePicker2.DateTime:= SQLDateTimeToDateTime(sqlexecute('select startdate from seasons where id=seasonname' ));

If I may ask. Why are you loading the datetimepicker field with a SqlExecute rather than letting MVD handle it on a form automatically? Since you have a null date, a check for it should be put in place. I modified the Pozidis example in another post for your situation. See if the attached is acceptable.

i use the weeksbetween to automatically give me the week number of play.  seemed like an easy way to do it to me.

Hi Lee,
I've attached your project with a couple of changes that I hope will give you what you're after.
I think there were 2 basic issues with what you were trying to do.
1.  You were trying to use the seasonname as the ID whereas the ID is always an internally generated number (have a look at the sqlite.db screen shot that's included in the attached .zip file), so it was never going to find a match.
2.  There was no reference on your matches form to which season you were wanting to use, so I have added a combobox so you can either select the season manually from the drop-down or, if you have previously highlighted a row in form1.tablegrid1, then the script will pass that record ID through to the matches form automatically.
Trust that makes sense.
Derek.