在win10 與 win 11 日期問題

Question

在win10 與 win 11 日期問題

d c 0

為什麼 access 寫的程式在 win 10 顯示的日期格式為中式日期.在 win 11 為西式日期

2 answers

Your answer

Answer 1

Vahid Ghafarpour 22,455

Ensure that the regional settings are the same on each operating system. Open "Settings" -> "Time & language" -> "Date & time" and check the regional settings.

d c 0 Reputation points

2024-01-01T12:42:12.2866667+00:00

設定均相同

d c 0

yy = Year(Date)
mm = Month(Date)
T1 = ""
T2 = ""

For i = 1 To 12
   T1 = T1 & Format(DateSerial(yy, i, 1), "e/mm/dd") & ";"
  T2 = T2 & Format(DateSerial(yy, i + 1, Day(DateAdd("m", 1, DateSerial(yy, i, 1))) - 1), "e/mm/dd") & ";"
Next
 Me.NUM1.RowSource = T1
Me.NUM2.RowSource = T2

d c 0 Reputation points

2024-01-01T12:51:54.0766667+00:00

上面 num1,num2 是combobox

在 win 10 時下拉顯式中式日期(113/01/01) 在 win 11 下拉時變成 2014/01/01
d c 0 Reputation points

2024-01-01T12:53:23.2966667+00:00

e/mm/dd 會變成中式格式
d c 0 Reputation points

2024-01-01T12:57:18.0433333+00:00

a1.png

Answer 2

d c 0

a1.png

Share via

在win10 與 win 11 日期問題

2 answers

Your answer