Make Blank Dates Show Up as Blank

[GNHP]

I have a date field - SALE.ReleaseDate - that is sometimes empty. If it is empty, it appears as 12/30/1899 on a report, but I want it to be blank. Even if it appeared as just 0 or 00/00/0000, that would be better than 12/30/1899.

Can this be done? Is there a formula for it or is it a formatting issue?

Many thanks in advance!

 

[lbass]

You could create a formula like:

if {SALE.ReleaseDate} = date(1899,12,30) then date(0,0,0) else
{SALE.ReleaseDate}

This should result in the appearance of a null field.

-LB

 

[GNHP]

That worked beautifully, of course!

I spend a lot of time trying to work out these things on my own and then I come here and someone gives me just the right answer within a few minutes. I love it!

I'm so grateful that experts put their personal time into these forums to help out those of us with limited knowledge/training.

I really appreciate it. Thanks so much!