If we have a BO that has a datetime column that we may at times want to use the date picker against in Strataframe what is the best method of setting the default in the BO Mapper and what is the difference between each method? IE... advantages, etc: FYI I mainly have used the first method which seems to work for SQL and Oracle.

First Setting: NULL VALUE OPTION = Return Alternate on Null / Set Null on Alternate (Value Type) and the NULL REPLACEMENT VALUE = new DateTime(1800, 1, 1)

Second setting:  NULL VALUE OPTION = Return Alernate on Null and the NULL REPLACEMENT VALUE = Convert.ToDateTime("1800-01-01 00:00:00.000")

The first option works two-way meaning that if you set the BO to the default value of 1-1-1800 then a NULL will be set out on disk. Whereas, the second option is one-way meaning that it is a return value only so if it see a value of NULL, it will return the alternate value which in your example would be 1-1-1800. So if you want two way, then you are better off with option 1.