-
Crystal Report Problem
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
-
I don't think there is a function for that. You can check for a null date by looking for the year 1899.
-
Thanx for your reply.
Do you mind giving me an example on using a null date?
Rgds.
KT
-
If {Claims.Date Resolved} = Date (1899,12,31) Then "N/A" Else
ToText (Date({Claims.Date Resolved}))