Enable Shipping Method on Schedule

[PatClay]

My default shipping is overnight Mon-Friday. I would like to add an option for Saturday delivery, but this would only make sense from Thursday at 3:30pm until Friday at 3:30pm (courier comes at 4pm).

I can set up another table shipping module, say 'saturday table', but need to be able to turn it on and off on a schedule. I don't believe that this is possible out of the box, but does anyone have any ideas about how to set a schedule for it?

I need to turn it on and off, otherwise people will order at 7pm on Friday night, choose 'Saturday delivery' and be unhappy when it doesn't arrive. Equally, if they order on Thursday morning, then it will be delivered on Friday, 'Saturday delivery' would be slower.

Am I able to set up a cron to run a sql to 'UPDATE shipping_module SET seturday_delivery=ON'?

If so, can someone point me to the right table?

Thanks for your help.

[lat9]

You could update the shipping module (near the top, where it determines whether it's enabled) to check the time and disable itself if it's too late in the day.