I would like to append bookings in a database that are older than 2 weeks old, what is the criteria to do this please? thanks

WHERE (((tablename.fieldDate)<Int(Now())-14));
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.