... for later use
Create a connection to Zoho Analytics:
ZohoDesk > Setup > Developer Space > Connections > Create Connection
Select Zoho Analytics and give the required scopes (I've cheated and gone ...
... but I spent over an hour before I gave up trying to get SWITCH to work. Instead I cheated and got the ordinal in the Transact-SQL query:
CASE DATEPART(DAY, [MyDateValue])
WHEN 1 THEN 'st'
...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.