日期只能接受一年 [英] can a date accept only a year
问题描述
我们输入的是mm / dd / yyyy，但有些日期字段只包含
年。可以约会一年，如果这是他们有的全部
吗？
它可以只用于2008年甚至00/00 / 2008
日期字段需要日期数据类型和有效日期数据类型。 2008年
或00/00/2008都不可接受。如果这一年对你的记录足够好（一天365天不等），那么任何一个月和一天都可以和另一个月一样好。选择一个。
Chris
Microsoft MVP
sparks写道：
>我们输入的是mm / dd / yyyy，但有些日期字段只包含
年。可以约会一年，如果这一切都是他们有的吗？
它可以只用于2008年甚至00/00/2008
-
通过AccessMonster.com发布消息
http://www.accessmonster.com/Uwe/For...ccess/200809/1
2008年9月15日星期一12:44:52 GMT，Chris O''C通过AccessMonster.com
< u29189 @ uwewrote：
>日期字段需要日期数据类型和有效日期数据类型。 2008年
或00/00/2008都不可接受。如果这一年足以满足您的记录（一天365天），那么任何一个月和一天都可以和另一个月一样好。选择一个。
Chris
Microsoft MVP
sparks写道：
>>我们正在输入mm / dd / yyyy，但有些日期字段只包含
年。可以约会一年，如果这一切都是他们有的吗？
它可以只用于2008年甚至00/00/2008
我告诉他们只需要一年的时间就可以输入01/01 / YYYY。
这样就可以了。他们同意并且正在从现在开始这样做。
他们问一个约会，但就像其他一切一样。没有人能记住某个日期，但是他们记得年份，有时甚至是月份。
我建议了一天的月份和年份字段。 3个字段用于存储日期。
这意味着19个字段变为57.依此类推。入场时出现更多错误
。
不要让它更容易出错。将它们保存为日期字段。
Chris
Microsoft MVP
sparks写道：
>我建议了一天的月份和年份字段。存储日期的3个字段。
这意味着19个字段变为57.依此类推。入境时出现更多错误
。
-
通过AccessMonster.com发布消息
http://www.accessmonster.com/Uwe/For...ccess/200809/1
We are entering mm/dd/yyyy but some of the date fields only contain
years. Can a date be made to only take a year entry if that is all
that they have?
can it be made to take only 2008 or maybe even 00/00/2008
A date field requires a date data type and a valid one at that. Neither 2008
or 00/00/2008 are acceptable. If the year is good enough for your records (a
365 day range) surely any month and day is as good as another. Pick one.
Chris
Microsoft MVP
sparks wrote:>We are entering mm/dd/yyyy but some of the date fields only contain
years. Can a date be made to only take a year entry if that is all
that they have?
can it be made to take only 2008 or maybe even 00/00/2008--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200809/1
On Mon, 15 Sep 2008 12:44:52 GMT, "Chris O''C via AccessMonster.com"
<u29189@uwewrote:
>A date field requires a date data type and a valid one at that. Neither 2008
or 00/00/2008 are acceptable. If the year is good enough for your records (a
365 day range) surely any month and day is as good as another. Pick one.
Chris
Microsoft MVP
sparks wrote:>>We are entering mm/dd/yyyy but some of the date fields only contain
years. Can a date be made to only take a year entry if that is all
that they have?
can it be made to take only 2008 or maybe even 00/00/2008
I told them to put in 01/01/YYYY for data with only a year.
So that sould work out ok. They agreed and are doing it that way from
now on.
They ask a date but just like everything else. No one can remember a
certain date but they remember the year and sometimes the month.
I suggested a day month and year fields. 3 fields to store the date.
This would mean 19 fields becomes 57. and so on. More error on entry
as well.
Don''t make it more error prone. Keep them as a date fields.
Chris
Microsoft MVP
sparks wrote:>I suggested a day month and year fields. 3 fields to store the date.
This would mean 19 fields becomes 57. and so on. More error on entry
as well.--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200809/1
这篇关于日期只能接受一年的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
