Formula to display ONLY dates that are > current date

[agray123]

I am running a report to list review and probation dates. Review dates are all in the future so there is no problem there but the process that ran to create probation dates simply added six months to thier original hire date, leaving me with all sorts of irrelevant data (prob date: 7-10-1974).

I am trying to create an if then else statement to say:
if {ADMINSERV_PROBDATES.PROBATION_DT}>= currentdate
then {ADMINSERV_PROBDATES.PROBATION_DT}
else ""
but get an error saying a date is required here ""

how can I get around this?

 

[Naith]

You're getting this fault because you're trying to mix a string output ("&quot with a date output.

Either remove the 'Else' clause, or change '""' to Date(0,0,0), and conditionally suppress the field on zero value.

Naith

 

[dgillz]

2 options:

1) Place the formula: {datefield}>=CurrentDate in the record selection formula to exclude non conforming data entirely.

2) Conditionally suppress the dates that are before CurrentDate

If you need help with either option let me know. Software Training and Support for Macola, Crystal Reports and Goldmine
714-348-0964
dgilsdorf@mchsi.com

 

[agray123]

If I conditionally supress this data, will the entire row be suppressed as well?

 

[Naith]

You suppress the section to suppress all the related fields, or the field to only suppress the date.

Both work on the same condition.

If you need to suppress the whole section, then I suggest that you follow dgillz record selection solution.

Naith