Strange SWITCH function behaviour

imtiazu · 06-08-2020 06:40 AM

Hi,

Any idea why “May” is being capitalized within my SWITCH function??
BTW this is pointless workaround to handle the fact that cards are converting my UK dates into US format, so if that issue could actually be fixed (ticket raised 2 weeks ago) then I wouldn’t need to do this.

Thanks
Immy

Steve

You should double-quote text values to avoid their interpretation in any special way: e.g., "May" instead of May.

Also consider this: TEXT([Date], "mmmm")`

See also:

Fabian_Weller

@Steve I also saw that AppSheet would turn a word into capital letters, when this word has 3 characters.
Like von would look like VON
So I had to put it into double-quotes.