Replacing a particular date and blank with Blank

building reports crystal reports
1

Hi,

I am trying to find a logic to replace a particular date and blank space from blank.

For e.g. have 01/01/1800 as a date and want to change it by blank. But other dates should remain intact. Also if there is any blank date, it it should remain blank.

aniketp :uk: (BOB member since 2007-10-05)

2

It should be simple enough. The big ‘issue’ is the the result will not be a date anymore from the formula, but a string.

Example

if {somedate} = date(1900,01,01) then ‘’
else cstr(somedate)

You may want to totext instead of cstr to get more control on the formatting.

kevlray :us: (BOB member since 2010-06-23)

3

Thank you so much for suggestion.

I managed to solve it by using date and totxt function. :slight_smile:

aniketp :uk: (BOB member since 2007-10-05)