Page 1 of 1
Converting date to Character
Posted: Mon Jun 10, 2013 11:20 am
by 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
=> RE: Converting date to Character
Posted: Fri Jun 14, 2013 11:24 am
by 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.