I have a direcectory of tables, one for each month (yyyymm.dbf), which I need to cycle through and delete all those older than 30 days.
SYS(2000) would let me cycle through all files in the directory and check if each one is older than the 30 days but this seems a very inelegant way of solving this.
Can anyone think of a cleaner way of achieving this?