Converting date to Character

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
BriInib
Posts: 1
Joined: Wed Feb 07, 2018 12:09 pm

Converting date to Character

Post by BriInib » Mon Jun 10, 2013 11:20 am

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
Does Latex Effect Keflex viagra cialis Can Amoxicillin Cause Yeast Infection Levitra Comprar En Espana

User avatar
cstrasser
Posts: 155
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: Converting date to Character

Post by cstrasser » Fri Jun 14, 2013 11:24 am

[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.
Chris Strasser
Liveware Publishing, Inc.
Work bigger.

Post Reply