Hey everyone, this is likely an easy one, but I'm new with Crystal so please be gentle.

I need to take a default date 11/8/1989 12:00:00AM
which is formatted as MM/DD/YYYY + Time

I need to use another date field but only pull records where the MONTH is 4 months from the default date. Can someone please point me in the right direction on this?

Thanks so much for your help.
Steve

The problem is that it will increase by 4 months from the date I reference. Which will include the year. I need to include the month number only, but i still need it to turn over after 12 months back to 1. This works but it includes the year. How can I set it to just check the month?

AddMonthsAndReturnEndOfMonth ( GetDataSetDate ( 'monthend' ),4))

Dblank!

Well done my friend!!! It works perfectly. Thanks so much for your help and to those who have responded! Greatly appreciated!


Steve