How do I update the product cost information starting from a specific date?

The best way to handle changing COGS values would be to use the database COGS setting. A full explanation of the setting is here: How does the "Database COGS Sync" work?