Button to remove data stored in a table that is a month old

[antm2209]

Hi,

I am trying to create a button that will delete records in a table that is a month old from todays date, as they will no longer be needed.

How could i do this, would i need to use a macro or query and if anyone could please tell me how i could accomplish this.

Any help would be great thank you

 

[bborissov]

LOCAL ldMonthOld
ldMonthOld = GOMONTH(DATE(), -1)
DELETE FROM YourTable FOR SomeDateField <[COLOR=blue]=[/color] ldMonthOld

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.
Microsoft MVP VFP

 

[antm2209]

Thank You so much for your time, just got it working