Solved QUERY CHOOSE + WEEKDAY FUNCTION (1 Viewer)

[georg0307]

Dear All,

an Italian problem.
Premise that all functions, in Italian MS OFFICE needs a semicolon ; instead of a simple comma , (requested in functions and formulas in the English office), so I can't get "CHOOSE" function result, WEEKDAY works perfectly, here below what I set in a query:
WDay: Format(Weekday([Date];1);"gggg")

but I need the wday in english.

So I have the following function NR_W: Weekday([Date];2) that give me nr

but the following Function is not working 2 ways I tried:

WeekD: Choose(Weekday([Date];2); "Mon"; "Tue"; "Wed"; "Thu"; "Fri"; "Sat"; ”Sun")
ERROR:

WeekD: Choose(Weekday([Date],2),"Mon","Tue","Wed","Thu","Fri","Sat",”Sun")

Both are not working for me.

Is there another way to have Wdays in englis? What am I doing wrong?

Thanks in advance,

Georg

 

[Gasman]

Could just use
format(date(),"ddd")

however
? choose(weekday(date(),2),"Mon","Tue","Wed","Thu","Fri","Sat","Sun")
works for me?
I would expect you need to use ; not , ?

 

[georg0307]

Hi the issue is on Italian Office where the Function are in english but separator needs semicolon, so I used your string I paste it with semicolon lowercase , lower , lower the only difference and now it works. Thank you a lot.

 

[Gasman]

I did not think case mattered? If you used it in VBA, intellisense would Proper it anyway?
I apologise as well for the format solution, as I missed you needed the days in English, not Italian

 

[georg0307]

In The End I Am A Little Bug But It Works !!! Thank you.