So I’m using ENCODEURL([Start Date]) in a workflow as part of a URL string that does a webhook to an SMS provider. The issue is I’m in the UK and its displaying in the SMS as MMDDYYYY and not DDMMYYYY. The date is in UK format in the App and the same in the spreadsheet. I’ve tried doing ENCODEURL(DATE([Start Date])) and changing the spreadsheet column formating from Date to Text. Both made no difference.
Does anyone have any suggestions. Or do I have to create a CONCATENATE() equation to force the issue