sql lite replicating the records by using triggers based on current date

Question

Hi, Im using sqllite in my palm-pre web os application,

i have the table with the following structure.

Spending(id,note,amount,date,recurringtype,type,isprocessed);

the value for the recurring type will be like daily,weekly monthly etc.(1,2,3..etc)

i need to replicate a record by checking the date and the recurring type. Can it be achieved with the triggers