Date time substitutions

markvivian · October 9th, 2004, 05:10 PM

I am trying to substitute a null date value (Blasted 12/30/1899) in my select statement. I

trying.

I am using VS 2003 C#. The datasource is Foxpro.
Any ideas :)!

pradeep_itguy · October 12th, 2004, 12:11 AM

Can you explain it more? I couldn't get what is your requirement!

It is not how much we do,
but how much love we put in the doing.

-Mother Theresa

markvivian · October 14th, 2004, 12:11 AM

I am trying to substitute a value of '0' in a datetime field and substitute the '0' value or '12/30/1899' with a default text value.
I tried the DataReader's IsDBNull() method but since the value is not null that wont work.