May 16, 2011 at 10:39 pm
Hi,
I want to move the records to another table if that record exceed 10 days
May 16, 2011 at 10:40 pm
Do you have any created date or updated date in the table? That would be the right key to purge the data.
May 16, 2011 at 10:49 pm
I have created date in my table.
May 16, 2011 at 10:55 pm
then its pretty easy as it is to move the records with the created date difference from the current date exceeds 10 days.
Use DateDiff function for the same.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply