Changing a Date to a Letter

[Yustrn]

Hello,

I'm using Crystal 7.0 and I need to know how to change a date to a letter using a formula. What I want to do is if I have someone who has a Termination Date, I want them to come out with just the letter T if they are not terminated then I want the letter A . All help is appreciated.

 

[MJRBIM]

I'm assuming that the field is NULL when there isn't a termination date...

NAME : {@EmployeeStatus}
FORMULA : IF IsNull({Table.TerminationDate}) THEN "A" ELSE "T"

 

[Yustrn]

Your the man!

 

[mattalin]

You could try something like this:

if termination date > 0 then "T" else "A"