Recurring Date formula needed - please

[adobi81638]

CR 8.5

I need a formula that will find all records on a 3 monthly basis from input date (for our company 3 month service calls - from input date and thereafter every 3 months - recurring).

Any help would be much appreciated.

 

[dgillz]

To find all the records within 3 months of the parameter date, create a record selection formula:

{MyDateField} in {MyDateParamter} to dateadd("m",3,{MyDateParameter})


In terms of recurring, I do not know what you mean by that in this context. Please take the time and space to clarify what you want, including posting of sample data and desired output. They do not charge by the word here at tek-tips.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz