Trying to get the day of the week (numeric)

[clive.pottinger]

Hello,

The help page for date formatting indicates that it is possible to get the "stand-alone day of week (Text/Number)" by using the 'c' symbol. However, no matter what I try, all I can get is the short textual day of the week:

Code: Select all

dow = "{getDate(1999,12,31), dateformat, c}";

gives me "Fri".

What do I need to do to get a returned value of 5 instead of "Fri"?

Many thanks.

[pmgnt]

dow = "{getDate(1999,12,31), dateformat, EEEE}"

[clive.pottinger]

dow = "{getDate(1999,12,31), dateformat, EEEE}"

Unfortunately, this returns "Friday", not 5.

[Desmanto]

I never realize there is pattern character 'c' there. I test the pattern and also get "Fri". Seems we missed something out to get the result as number. Trying multiple 'cccc' also give "Friday".

I used to face the same problem, but I simply solved it using division and modulus.

Code: Select all

dow = (getDate(2018,2,10)/ 86400000 + 5) % 7;

divided by 86400000 miliseconds will give result in days after 1 January 1970. Plus 5 because the starting day at 1 January 1970 is Thursday (index 4 from 0 based on Sunday), but my GMT+0700 deduct 7 hours to be less than 1 January 1970. So Friday, 2 January 1970 will be evaluted to 0 at the modulus 7; it should 5 (from 0 based). That's why I plus 5. Depends on your timezone, you maybe need to +4 instead.

[pmgnt]

dow = "{getDate(1999,12,31), dateformat, EEEE}"

Unfortunately, this returns "Friday", not 5.

Sorry my bad. Didnt read the question correctly.

[clive.pottinger]

I never realize there is pattern character 'c' there. ... I used to face the same problem, but I simply solved it using division and modulus.

Code: Select all

dow = (getDate(2018,2,10)/ 86400000 + 5) % 7;

Thanks Desmanto. I knew I could do it arithmatically; I just thought I was using 'c' incorrectly. Good to know it doesn't actually work as indicated.

Sorry my bad. Didnt read the question correctly.

No problem.

[Martin]

Hi,

'c' is a strange one that returned the text presentation on most or even all devices. Seems that Google also removed it from the documentation for some reason.
Google added a new pattern 'u' on Android 7+ to get the numeric day of week. I recommend to use this one if you're on a current version of Android.
I'll update the documentation and mark 'c' as deprecated.

Regards,
Martin

[clive.pottinger]

Thanks again. Using 'u' worked.