Pranoy
Active Member
Hi All,
I'm working on purging the old worktable orphan records till the date = today's date - 2. I.e. all the records in table where Table.UPMJ <= (today's date - 2)
i see that in delete table io we don't have option to use '<=' operator but only '='.
Right now I'm thinking to create a custom section on the worktable selecting the records which are <= (today's date - 2) and then in LBH/LBF I do a delete table io on UKID
any suggestions please?
Thanks,
Pranoy
I'm working on purging the old worktable orphan records till the date = today's date - 2. I.e. all the records in table where Table.UPMJ <= (today's date - 2)
i see that in delete table io we don't have option to use '<=' operator but only '='.
Right now I'm thinking to create a custom section on the worktable selecting the records which are <= (today's date - 2) and then in LBH/LBF I do a delete table io on UKID
any suggestions please?
Thanks,
Pranoy