Strange SWITCH function behaviour

[imtiazu]

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:

help.appsheet.com

Text Expressions

Text expressions use and/or produce textual values.

help.appsheet.com

TEXT()

Format as text

[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.