日期会自动更改 [英] date is automatically changed
问题描述
你好专家'
当日期是在12月之后它完全正常工作。如果日期在12日之前，那么
只会恢复为美国格式。
给出解决方案
谢谢你
hello experts''
when the date is after the 12th of the month it is all working fine. It
only reverts to US format if the date is before the 12th.
Give solutions
Thank you
推荐答案
什么???
如何更详细地解释您的问题是什么。
comteck
WHAT???
How about a little more detail explaining what your problem is.
comteck
我想我知道你在说什么，我遇到了同样的问题，但没有解决方案。
在使用西班牙语版本的Access 2002时，我创建了一个querydef，其中一个字段是一个日期，其标准在文本框中以dd / mm / yyyy格式指定。当Access创建查询时，我打开它以发现条件中的日期具有月份和日期自动切换，但仅针对日期< 12 ......
不知道如何解决它
Hi, I think I know what you are talking about and I am having the same problem, but don′t have a solution.
When working on a Spanish version of Access 2002 , I create a querydef where one of the fields is a date with criterias specified in a textbox in the format dd/mm/yyyy. When Access created the query, I open it to find that the date in the criteria had the month and the day switched automatically, but only for the dates where the day < 12......
no idea how to solve it
我想我知道你在谈论什么，我遇到了同样的问题，但没有解决方案。
在使用西班牙语版本的Access 2002时，我创建了一个querydef，其中一个字段是一个日期，其标准在文本框中以dd / mm / yyyy格式指定。当Access创建查询时，我打开它以发现条件中的日期具有月份和日期自动切换，但仅针对日期< 12 ......
不知道怎么解决它
Hi, I think I know what you are talking about and I am having the same problem, but don′t have a solution.
When working on a Spanish version of Access 2002 , I create a querydef where one of the fields is a date with criterias specified in a textbox in the format dd/mm/yyyy. When Access created the query, I open it to find that the date in the criteria had the month and the day switched automatically, but only for the dates where the day < 12......
no idea how to solve it
我自己在一些数据库上发现了这个问题。我通常通过在表格中的字段上强加日期格式来解决它，因为它似乎只发生在控件上。通过一个未绑定的控件，我发现强加一种格式似乎有效。
我不知道为什么它会在某些数据库中发生而在其他数据库中不会发生。我只能假设设计师有美国格式的系统设置，引擎以某种方式记住了这一点。也许我们的其他一些专家会有更好的主意。
Mary
I''ve noticed this problem myself on some databases. I usually resolve it by imposing a date format on the field in the table as it only seem to happen with controls. With an unbound control I find that imposing a format seems to work.
I don''t know why it happens in some databases and not in others. I can only assume that the designer had their system settings on US format and the engine somehow remembers this. Maybe some of our other experts will have a better idea.
Mary
这篇关于日期会自动更改的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
