Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Saving a Datetime DataSource

Good Day

Experts:

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:

WOForm.Items.Item("txtCompDte").Specific.value

WOForm.DataSources.UserDataSources.Item("u_DemDue").ValueEx

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,

Ed

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question