How to get blank dates to return from VFP data

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

How to get blank dates to return from VFP data

Message

From

02/12/2004 16:29:36

Jon Rosenbaum
Millennium Systems International
Parsippany, New Jersey, United States

02/12/2004 15:03:24

R Matthew Songer
Classic Design Services, Inc
Atlanta, Georgia, United States

General information

Forum:

Visual FoxPro

Category:

Crystal Reports

Title:

Re: How to get blank dates to return from VFP data

Environment versions

Visual FoxPro:

VFP 6 SP5

OS:

Windows 2000 SP4

Network:

Windows 2000 Server

Database:

Visual FoxPro

Miscellaneous

Thread ID:

00966206

Message ID:

00966516

Views:

This message has been marked as a message which has helped to the initial question of the thread.

>It looks you'll need to give me a hint. I'm still not getting anywhere.

The way I've been able to do is to test for the field value against Date(1899,12,30). Checking for null values using IsNull() will not help at all since, as Craig pointed out, the ODBC driver is returning an actual value.

Laterness,
Jon

Jon Rosenbaum
Devcon Drummer

Map

View

Click here to load this message in the networking platform