A2K - 仍有轻微的约会问题...... [英] A2K - still have a slight date problem...
问题描述
我使用两个日期(From和To)生成报告。我注意到如果我输入
01/10/2003它被Access解释为10/01/2003,即1月10日
,而不是我想要的10月1日。
这是美国日期格式的老问题mm / dd / yy与dd / mm / yy。
我正在逐步完成代码和日期似乎没问题,但是当
报告运行时,我得到的记录早于10月1日,这不是我想要的。
关于如何允许的任何想法用来输入dd / mm / yyyy格式并且那个
的日期不要被Access误解?
这让我非常便利。
谢谢
马丁
Hi,
I generate a report using two dates (From and To). I notice if I enter
01/10/2003 that it is interpreted by Access as 10/01/2003 i.e 10th January
rather than 1st October as I intended.
This is the old problem of US date format mm/dd/yy versus dd/mm/yy.
I am stepping through the code and the dates do seem to be ok but when the
report runs I get records earlier than 1st October which is not what I want.
Any ideas on how to allow the use to enter in dd/mm/yyyy format and for that
date not to be misinterpreted by Access??
This is driving me quite potty.
thanks
Martin
推荐答案
" Deano" <毫安************ @ hotmail.com>在消息中写道
新闻:SC ******************* @ wards.force9.net ...
"Deano" <ma************@hotmail.com> wrote in message
news:SC*******************@wards.force9.net...
我使用两个日期(From和To)生成报告。我注意到,如果我输入
01/10/2003,它被Access解释为10/01/2003即1月10日
而非10月1日,正如我的意图。
这是美国日期格式的老问题mm / dd / yy与dd / mm / yy。
我正在逐步完成代码并且日期似乎没问题但是当
报告运行时我得到了记录早于10月1日,这不是我想要的b $ b。
关于如何允许使用dd / mm / yyyy格式和
的任何想法,这些日期不会被Access误解??
这让我非常便利。
Hi,
I generate a report using two dates (From and To). I notice if I enter
01/10/2003 that it is interpreted by Access as 10/01/2003 i.e 10th January
rather than 1st October as I intended.
This is the old problem of US date format mm/dd/yy versus dd/mm/yy.
I am stepping through the code and the dates do seem to be ok but when the
report runs I get records earlier than 1st October which is not what I want.
Any ideas on how to allow the use to enter in dd/mm/yyyy format and for that date not to be misinterpreted by Access??
This is driving me quite potty.
我最近遇到了同样的问题并被告知Access总是比较
$ b $b日期在VB SQL代码中以mm / dd / yyyy格式表示。
我认为它适用于其他地方的国际设置,除非
另外格式化。
希望这有帮助
Ken
I recently had the same problem and was informed Access always compares
dates in mm/dd/yyyy format in the VB SQL code.
I think it works with your International settings everywhere else, unless
otherwised formatted.
Hope this helps
Ken
" Deano" <毫安************ @ hotmail.com>在消息新闻中写道:< SC ******************* @ wards.force9.net> ...
"Deano" <ma************@hotmail.com> wrote in message news:<SC*******************@wards.force9.net>...
>
我使用两个日期(From和To)生成报告。我注意到,如果我输入
01/10/2003,它被Access解释为10/01/2003即1月10日
而非10月1日,正如我的意图。
这是美国日期格式的老问题mm / dd / yy与dd / mm / yy。
我正在逐步完成代码并且日期似乎没问题但是当
报告运行时我得到了记录早于10月1日,这不是我想要的。
任何有关如何允许使用dd / mm / yyyy格式以及日期不被Access误解的日期的想法??
这让我非常便利。
感谢
Martin
Hi,
I generate a report using two dates (From and To). I notice if I enter
01/10/2003 that it is interpreted by Access as 10/01/2003 i.e 10th January
rather than 1st October as I intended.
This is the old problem of US date format mm/dd/yy versus dd/mm/yy.
I am stepping through the code and the dates do seem to be ok but when the
report runs I get records earlier than 1st October which is not what I want.
Any ideas on how to allow the use to enter in dd/mm/yyyy format and for that
date not to be misinterpreted by Access??
This is driving me quite potty.
thanks
Martin
如果你的日期是表单,您可以格式化日期格式为英语(dd-mm-yyyy)格式而不是美国格式。无论是那个还是
强制查询中的格式(只是以
函数的格式包装输入)
If you get your dates from a form, you can format the date there to be
in English (dd-mm-yyyy) format instead of US format. Either that or
force the format in your query (just wrap the input in the format
function)
除了你已经得到的反馈(所有这些都是正确的,
BTW)之外,请查看Allen Browne的访问中的国际日期。在
http://users.bigpond.net .au / abrowne1 / ser-36.html
-
Doug Steele,Microsoft Access MVP
http://I.Am/DougSteele
(请不要发私人电子邮件)
" Deano" <毫安************ @ hotmail.com>在消息中写道
新闻:SC ******************* @ wards.force9.net ...
In addition to the feedback you''ve already got (all of which is correct,
BTW), check Allen Browne''s "International Dates in Access" at
http://users.bigpond.net.au/abrowne1/ser-36.html
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(No private e-mails, please)
"Deano" <ma************@hotmail.com> wrote in message
news:SC*******************@wards.force9.net...
我使用两个日期(From和To)生成报告。我注意到,如果我输入
01/10/2003,它被Access解释为10/01/2003即1月10日
而非10月1日,正如我的意图。
这是美国日期格式的老问题mm / dd / yy与dd / mm / yy。
我正在逐步完成代码并且日期似乎没问题但是当
报告运行时我得到了记录早于10月1日,这不是我想要的b $ b。
关于如何允许使用dd / mm / yyyy格式和
的任何想法,这些日期不会被Access误解??
这让我非常便利。
感谢
Martin
Hi,
I generate a report using two dates (From and To). I notice if I enter
01/10/2003 that it is interpreted by Access as 10/01/2003 i.e 10th January
rather than 1st October as I intended.
This is the old problem of US date format mm/dd/yy versus dd/mm/yy.
I am stepping through the code and the dates do seem to be ok but when the
report runs I get records earlier than 1st October which is not what I want.
Any ideas on how to allow the use to enter in dd/mm/yyyy format and for that date not to be misinterpreted by Access??
This is driving me quite potty.
thanks
Martin
这篇关于A2K - 仍有轻微的约会问题......的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!