# 2718 Setting a Date/Time Value in .NET Data Provider Causes Invalid Cast Error

---

I'm having serious problems using the Date datatype with ASP.NET.

Lets say I have the following table definition

UID Integer
RegDate Date

and the following data
1 12/13/1994
2 11/17/1999

When I display the data in a Grid (either the standard GridView or Developer Express APSXGridView) the data is shown as
1 12/13/1994 12:00:00 AM
2 11/17/1999 12:00:00 AM

Notice that 12:00:00 AM is displayed as if it was a DateTime field. (.NET does not have a Date datatype, only a DateTime datatype so I don't know if the time part is added by you or the .NET framework)

If I edit and try to update the record I get an error "Specified cast is not valid" and an Exception is thrown.

[InvalidCastException: Specified cast is not Valid.]
Elevate.ElevateDB.Data.Engine.TEDBValue.SetAsVariant(Object Value) + 606