Calendar.MonthsShort() - bugs reported for iOS

[hpkeong]

Hi PG:

When creating a DropDown, with Distinct(Calendar.MonthsShort()),

- Android: it will show "Jan", "Feb",....with First Capital Letter (Proper mode)

- iOS: it will show "jan", "feb",..... with small letter

Inconsistency between iOS and Android resulting in Filtering problem.

Tempoerary solution:

DropDown.Items = ["Jan", "Feb", ................, "Dec"]

I would suspect reported issues in this Forum on Filtering with DATE

- If data is saved using Apps in iOS and Android, date will be saved in different format and this will result in WRONG Calculation or comparison.

iOS: save 25-Mar-2017 as 25-mar-2017

Android: save 25-Mar-2017 as 25-Mar-2017 

Looks like a very serious bug. I will have, from  now on, to change and use numerial date:

e,g,: 25-03-2017

I will continue to check.

Would PG Investigate this issue?

TQ 

[v-micsh-msft]

Hi @hpkeong,

Issue confirmed.

I will collect this from my side, and if I got any feedback, I will post back.

Regards

[hpkeong]

HI

Thanks. Awaiting your investigation.

It happened on Asus Laptop (with exactly similar  setting to SP$, BUT SP4 is perfect), too , as 27-mar-2017, as of iPhone

TQ

[hpkeong · Accepted solution]

Hi

I have a different session discussion with Audrie, and with her suggestion of using:

Proper(Text(Today(),"dd-mmm-yyyy"))

to force the first letter as capital, and i tried on

- SP4, Asus Laptop, Android Phone, Dynamics 365 Web Apps (it was having all lower case, 27-mar-2017, but I forgot to report)

Results: Perfectly done. Now data are forced to save as 27-Mar-2017, and even in Dropdown are are forced to Proper mode and

Filter & Sort are perfect.

Appreciate with prompt response and thanks to @audrie for solution.

Anyhowm I wisht PG has some ideas on why this happens or by defaults?

Thanks and wish this will help other as well.

TQ

[AndyPennell]

Please report the values that the Language() function returns on these different devices. The casing of the month names will vary by locale.

[hpkeong]

Hi

Language() shows en-US.

Anyway, Proper can show the problems at of now, but I wish there should be permanenet solution instead of Proper.

Meantime, if the user is using another languge, say Chinese or Spanish, the date will show in their languages, not in English.

Is there anyway here to FORCE the language to use ONLY ENGLISH, esp for the date, say, 27-Mar-2017 to permanently showing English - Mar?

TQ

[AndyPennell]

If you always want the month emitted in English, use the third argument to the Text function to force it so. eg

Text(datefield, "mmm", "en-US")

 Meanwhile if you have a device reporting Language() as "en-US" and Calendar.MonthsShort giving a lower-case result, please capture the sessionId of the Player when it runs so I can investigate further.

[hpkeong]

Hi

Thanks for the guidance and it drives me to re-read the tutorial 101% of Text(...) so that I can fully utilized and share with others if same doubts as me arisen.

- Text(datefield, "mmm", "en-US") definitely works for datefield. - OK! Done!

Bugs

Language() as "en-US" and Calendar.MonthsShort giving a lower-case result

- Yes it really happened with

1. lower case even with Language() is "en-US" and UNLESS I use Proper (as @audrie has shared bofore)

[bugs in iOS and Dynamics 365 (Web Apps on Win Phone Lumia & Android Phone).

Win 10 SP$ is always PERFECT.

Android Phone PowerApps is also PERFECT

2. for DropDown where I use Calendar.MonthShort(), I can use Proper to force Capital letter for the first letter, but the language witll follow to user UI Language. I have tested with Chinese PRC, and it shows 三月 (for Mar) - so, I have no choice and change the Dropdown items to : ["Jan", "Feb", ..................., "Dec"] so that it will match with DATE saved in datasource (such as 27-Mar-2017, where I use Left(Right (......., 8), 3) to match.

Sorry for not sharing ScreenShot as I have to speed up the apps for commercial use today, and change all the 3 apps concurrently.

Note:

I would suggest that PG staff please use Android to test. I know almost all Windows PG staff used iPHONE, ad iPhone is so cheap and popular in USA, but Android concurs the rest of the world for 80%++, and most of the apps we write are for normal people in Commercial use. Here, iPhone are mostly for PERSONAL Use. When comes to commercial, it is always Android Phone goes first, esp. Powerful Huawei P8, P9, P10, Vivo, Oppo, Xiaomi, ...