Does anyone know a way to get Crystal to look for dates 14 days or more past a given date? I'm using Crystal reports 9 and I've tried using the DateDiff function like so.
DateDiff("d",{?StartDate},{Command.RecDate})<=14
but I'm not getting the results I want. I also tried using it in an SQL command query in my original selection with no luck any ideas?got it resolved thank you.|||In the record selection for your Crystal Report (http://www.shelko.com) you can use a formula similar to:
{myDate} >= ({?Start Date}+14)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment