Solved: ENCODEURL([Start Date]) in MMDDYYYY format - Page 2

1minManager · 01-31-2020 07:43 AM

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

Steve

If [Start Date] is already a Date, DATE([Start Date]) is redundant and unnecessary.

TEXT([Start Date]) will format the Date value according to your locale and whatever format-affecting settings the Start Date column has (e.g., Use long date format).

The TEXT() function can also be given a format string to format Date (or Time or DateTime) values exactly as you want.

View solution in original post