Converting date to Character

[BriInib]

Is there a way in R&R to convert a date to a character? __eg: if date 6/6/2013 is <90 print "Yes"____Thank you

[cstrasser]

[updated:LAST EDITED ON Jun-14-13 AT 11:25 AM (EST)]It sounds like you^re trying to evaluate a date for something like Accounts Receivable aging. The formula you^re looking for is:____IIf(Date_rr - {6/9/2013} > 90, "Yes", " ")____Which in words says: If the difference between "today" and 6/9 is more than 90 days, then display the word "Yes" otherwise display a blank space.____Date_rr is a calculated field that gets created within every new report and represents "today^s" date.