In this example, records are tagged with a Date attribute on initial ingest. No updates are necessary.
RETURN Result AS
SELECT
EXTRACT(CURRENT_DATE,
JULIAN_DAY_NUMBER) -
EXTRACT(Date, JULIAN_DAY_NUMBER)
AS AgeInDays
FROM SaleState
HAVING (AgeInDays < 30)