MySQL using different timezone to workplace setting
I've just discovered that cards will use the workplace setting for a timezone, [e.g. AEST] whereas MySQL Dataflows will use GMT. I'm trying to sum total sales by month, to then apply a monthly commission formula. This sort of structure: |Month | Sales | Commission| |2017-09|10,000|3,000| |2017-10|12,000|4,000| Where Month…