Formatting null dates for display in VB.Net

[ProtocolPirate]

I tried doing a "SELECT IFNULL(DateField, '1111-1-1')" as well as "SELECT IFNULL(DateField, CAST('1111-1-1' AS DATE))" but I always get the following errors:

[ODBC Engine Interface]Error in row.
[ODBC Engine Interface]Invalid date, time or timestamp value.
[ODBC Engine Interface]Expression evaluation error.

How can I format a date field so that my VB.Net program doesn't blow up on null date fields?

 

[genomon]

FYI IFNULL and CAST aren't Access VBA. Maybe get better guidance in the vb.net forum?

"Before you criticize someone, you should walk a mile in their shoes.
That way, when you criticize them, you're a mile away and you have their shoes."

 

[ProtocolPirate]

They aren't VB.Net, they are SQL statements.

 

[ProtocolPirate]

IFNULL and CAST are SQL statements, just like the SELECT command I also mentioned. It is not VB.NET. My questions has nothing at all to do with VB.NET, I should not have even mentioned it, it was obviously only a distraction.

 

[Remou]

Unfortunately, these are not Jet SQL. Is you database SQL Server or Access?

 

[genomon]

I think you'll have better luck in Microsoft SQL Server: Programming Forum.

"Before you criticize someone, you should walk a mile in their shoes.
That way, when you criticize them, you're a mile away and you have their shoes."

 

[dhookom]

I believe the correct syntax in SQL Server is:

  SELECT I[b][red]S[/red][/b]NULL(DateField, '1111-1-1')

Duane MS Access MVP

 

[genomon]

Yup, and there is also its evil twin, NULLIF.

"Before you criticize someone, you should walk a mile in their shoes.
That way, when you criticize them, you're a mile away and you have their shoes."

 

[ZmrAbdulla]

IIF() & Nz() functions are too there in access

________________________________________________________
Zameer Abdulla
Help to find Missing people