Weird Day name problem

[Gasman]

Hi all,

I had a query about some data in a database of mine, that records employee hours.
I used a computer in the directors office to open up the DB and check the data.
Data was fine, in respect of the query was resolved, however I noticed that in a form, the Day name did not reflect the correct name for the Date.

Pic in question is SRVPC-PIC.
My computer shows pic My-PIC.

DB is split FE & BE with individual FE.

Value comes from the query supporting the form and is evaluated as

DayName: nz(WeekdayName(Weekday([tblEmployeeDay].[DayDate],2),True),"")

Both computers are on Win10.

Can anyone please think of why this has occurred?

I must say I am relieved that this is the problem, as at first I thought I had made a huge error that I had not noticed up until now.

TIA

 

[Minty]

PC Regional settings ? The weekday setting takes a offset https://support.office.com/en-gb/ar...c96ea0351940?ui=en-US&rs=en-GB&ad=GB&fromAR=1 Which somehow may be different on his machine.

 

[Gasman]

PC Regional settings ? The weekday setting takes a offset https://support.office.com/en-gb/ar...c96ea0351940?ui=en-US&rs=en-GB&ad=GB&fromAR=1 Which somehow may be different on his machine.

Thank You Minty,

Hit the nail right on the head. Although the rest of the date settings were the same, the First day of The Week (never even knew this existed until now. I thought you had to specify in code?) was set to Sunday.

 

[static]

DayName: Format([tblEmployeeDay].[DayDate], "ddd")

 

[Gasman]

DayName: Format([tblEmployeeDay].[DayDate], "ddd")

Thanks static,
I'll try that on Monday.
Is there no need to use the Nz function with that?

 

[static]

Won't do any harm, but I don't think it's necessary.