Saving a Datetime DataSource
I am having all kind of trouble trying to figure out how to save a blank Datetime datasource defined field to a SQL Server 2005 database field defined as Datetime.
When adding a record to one of our AddOn screens, several fields defined as Datetime datasource and Datetime in the database are not required to have any data(valid date) in them. Here is what I have tried using:
The variable declared at the top of my S/P that I am calling is defined as datetime since the target field is defined as datetime.
How do I pass the data or potentially lack of data to this datetime field so I don't end up with 1/1/1900 in the table? This creates a problem since then 1/1/1900 is then shown back on the screen instead of a blank field.
Thanks for the help,