Blank Date Fields 1

[zircom]

I have a report that shows me reported dates and response dates.

I want to pick out those that are blank in any of the fields for audit purposes.

Thanks

 

[FoxG]

Hi,

Try using a record select formula something like:-

isnull({datefield_1}) or
isnull({datefield_2})

if that doesn't work, try

{datefield_1} = date(0000,00,00) or
{datefield_2} = date(0000,00,00)


Hope this helps

Geoff

 

[zircom]

Thanks for your quick response.

I will let you know