>Hi all,
>
>I have to create a function where I need to flag a record where the (RecordDate - 2 months) <= date(). I'm not sure how to do it. Can I just create something like an arithmetic statement to do the job??
Pretty trivial; you can add or subtract months to a date using GOMONTH, so try something like:
IF GOMONTH(dMyDateField,-2) <= DATE()
You can add days by simple arithmetic; for example, two days ago would be:
DATE()-2