Public Holidays

Profitdiagnostix get all holiday dates using the Google calendar API. Theoretically these can be split into different regions and aplied across different coutries or states. However currently the system has only been set up to read and utilise all Australian public holidays equally across all states.

Public holiday dates are stored in advance in the dash_time_event table

The general rule is that text messages will not be sent for 5 days on either side of a public holiday. eg. For Christmas the last send will be approx on the 19th December. But then with New years day being on the 1st, the messages will not be sent on the 31 Dec (5days after Christmas) because New years day blocks anything from the 26th Dec to the 6 Jan. So over the Christmas break no messages are sent from the 19 Dec to approx 6 Jan.

To filter out other event types in the table that are manually added by users, use this query:

SELECT * FROM public.dash_time_event 
WHERE  event_type ='Holiday' and region is not null
ORDER BY event_start DESC