Kentico BizFormItem

This code checks when the FormInserted is not empty then delete the records from the ContactUs form.

I want to change it and to do it when the FormInserted(date) is greater than on year then to delete the records from the ContactUs form.

ObjectQuery<BizFormItem> data = BizFormItemProvider.GetItems(formClassName).WhereNotEmpty("FormInserted");

bizformitem kentico 12 class

Then you'd update your where clause to something like this:

.Where("FormInserted < DATEADD(day, -365, GETDATE())")

1 votesVote for this answer Unmark Correct answer