Date Range problem

[tyrahat]

Using Crystal 8.5 with Sybase 12

I have a field: LSTCNTDT (last contact date) for my customers. I want to query and show the customers who have had a last contact date of <=5 days ago based on today's CURRENTDATE.

I'm stumpted. I've tried to do a Record Selection statement and use Between for the ranges but it's not working.

Help is welcome and appreciated!!

Thanks!!

 

[lynchg]

Give more detail, what did you try to do?

 

[tyrahat]

As stated, I tried a Record Selection formula but it didn't work.

Stumped as to how to do the formula.

Thanks

 

[lynchg]

Post the formula you tried to use, it may just need some tweaking.

 

[lbass]

If you mean you want dates within the last five days including today's date, try:

{table.lstcntdt} >= currentdate - 4

-LB