Using Crystal 11; I have a report that we need to say:
if cc.close.date is a Friday then +4 days and give me that date else
if cc.close.date is a Saturday then +3 days and give me that date else
if cc.close.date is a Sunday then +2 days and give me that date else
if cc.close.date is a Monday then +1 day and give me that date else
I have been thinking too long about this, probably over confused myself and just need some ideas. It's an actual DATE field, so I think I am just over complicating the fact that I need to know the 'day' vs. date and then bring me back a date value. Thanks in advance!
IP Logged
