Crystal Report Problem

[kleagle]

Hi folks,

Similar to IsDate() in Visual Basic, does Crystal Report 7.0 has any function that works like that?

I am trying to populating a list of date in one month, but when it comes to an invalid date (e.g. 31 Apr, 30 Feb), it will prompt an error about the date range.

I went through the date and date range function index, but couldn't find anything which return bool for verifying date and time format, nor can I find something to give me the maximum number of days in a month.

Can someone help me please?

Thank you. Regards.

KT

[ELampman]

I don't think there is a function for that. You can check for a null date by looking for the year 1899.

[kleagle]

Thanx for your reply.
Do you mind giving me an example on using a null date?
Rgds.

KT

[ELampman]

If {Claims.Date Resolved} = Date (1899,12,31) Then "N/A" Else
ToText (Date({Claims.Date Resolved}))