I have a form that i use on a timer, there is a do command that will run a query that will update as every 30 seconds

I wish to have a label that will display the time and if possible date the last time the do command was run.

It would also be handy to see a countdown to when the do command would be run again

as i have the timer set to 300000 i would like a countdown timer from 30 to 0 each time its run

can anyone illustrate a way i could do this please?

thank you