Hi,
Every hour i am doing my own set of transaction counting in a variable which i wish to reset on an hourly basis.
I can't seem, no matter what conditions, to get it to work properly, and only have a workaround where i have a seperate trigger for each hour of the day where i reset the transaction count to 0 one time only. This obviously only works for a period of 24 hours. When i tried to have one trigger with incrementing 'OR' conditions to check the hour, it was doing it across multiple markets that i was tracking, and therefore resetting it a number of times within that minute, and thus not counting the transactions within that first minute properly.
Would anyone have any suggestions as to what i could put into my trigger to do this only one time per hour as my logical thinking in this one aspect seems to be gone!