Hiya Perry ---
Use the GOMONTH() function. For example ?GOMONTH(DATE(),-2) will return {09/04/1998}.
>
>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??
>
>TIA
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
