年龄日期 [英] AGE DATE
问题描述
这显然已经多次完成了,但我看过的所有内容都是难以理解的,或者根本就不起作用。
这不适用于我的报告:datediff(yyyy,[DOB],现在())
这也不是:= datediff(" yyyy",[ DOB],现在())
有谁可以建议为什么?
关于如何做到这一点还有很多其他的建议,但是我什么都不能上班
。我只想在报告字段中输入年龄基于
某人的出生日期= DOB作为字段名。
This has apparently been done many times, but everything I''ve looked at
is either incomprehensible or simply doesn''t work.
This doesn''t work on my report: datediff("yyyy",[DOB],now())
Nor does this: =datediff("yyyy",[DOB],now())
Can anyone suggest why?
There are many other suggestions as to how to do this, but I can''t get
any to work. I just want to enter the age in a report field based on
someone date of birth = DOB as fieldname.
推荐答案
ch**********@isuga.fr 写道:
ch**********@isuga.fr wrote:
这显然已经完成了很多次,但是我看过的所有内容
要么难以理解,要么根本无法工作。
这对我的报告不起作用:datediff(yyyy,[DOB],现在())
这也不是:= datediff(yyyy,[DOB],now())
This has apparently been done many times, but everything I''ve looked at
is either incomprehensible or simply doesn''t work.
This doesn''t work on my report: datediff("yyyy",[DOB],now())
Nor does this: =datediff("yyyy",[DOB],now())
那个应该有效。
DOB字段是空的吗?
你不能说什么不起作用所以很难确定什么是错的
That one should work.
Is the DOB field empty?
You don''t say what doesn''t work so it''s hard to determine what is wrong
>
有人能说明原因吗?
关于如何做到这一点,还有很多其他的建议,但是我不能得到
工作。我只想在报告字段中输入年龄,基于
某人的出生日期= DOB作为字段名。
>
Can anyone suggest why?
There are many other suggestions as to how to do this, but I can''t get
any to work. I just want to enter the age in a report field based on
someone date of birth = DOB as fieldname.
Hard告诉你问题是什么,但我现在可以告诉你,你不会总是用这个公式得到准确的答案。如果
日期是9月9日,并且这个人是10月4日出生的,他将会看起来比他实际年龄大一岁。
ch**********@isuga.fr 写道:
Hard to tell what the problem is, but I can tell you right now you''re
not always going to get an accurate answer using that formula. If the
date is Sept 9 and the person was born Oct 4, he''s going to appear to
be a year older than he really is.
ch**********@isuga.fr wrote:
这显然已经多次完成了,但是我看过的所有内容
要么难以理解,要么根本无法工作。
这对我的报告不起作用:datediff(yyyy,[DOB],现在())
这也不是:= datediff(yyyy,[DOB],现在())
有人可以提出建议吗?
那里关于如何做到这一点还有很多其他的建议,但我不能得到
任何工作。我只想在报告字段中输入年龄,基于
某人的出生日期= DOB作为字段名称。
This has apparently been done many times, but everything I''ve looked at
is either incomprehensible or simply doesn''t work.
This doesn''t work on my report: datediff("yyyy",[DOB],now())
Nor does this: =datediff("yyyy",[DOB],now())
Can anyone suggest why?
There are many other suggestions as to how to do this, but I can''t get
any to work. I just want to enter the age in a report field based on
someone date of birth = DOB as fieldname.
我使用一个功能来显示年龄:
(注意 - 空气代码)
公共职能年龄(Bdate as date)为整数
年龄=年(日期) - 年(Bdate)
''如果受试者没有减去1今年有他们的生日
如果格式(日期,''mmdd'')<格式(Bdate,''mmdd'')然后
年龄=年龄 - 1
Endif
结束功能
>
Fred Zuckerman
" ManningFan" < ma ******** @ gmail.com写信息
新闻:11 ********************* @ i3g2000cwc.googlegrou ps.com ...
I use a function to display age:
(caution - air code)
Public Function Age(Bdate as date) as integer
Age = Year(Date) - Year(Bdate)
'' Subtract 1 if subject hasn''t yet had their birthday this year
If Format(Date,''mmdd'') < Format(Bdate,''mmdd'') Then
Age = Age - 1
Endif
End Function
Fred Zuckerman
"ManningFan" <ma********@gmail.comwrote in message
news:11*********************@i3g2000cwc.googlegrou ps.com...
很难说出问题所在,但我现在可以告诉你
并不总能使用该公式得到准确的答案。如果
日期是9月9日,并且这个人是10月4日出生的,他将会看起来比他实际年龄大一岁。
ch**********@isuga.fr 写道:
Hard to tell what the problem is, but I can tell you right now you''re
not always going to get an accurate answer using that formula. If the
date is Sept 9 and the person was born Oct 4, he''s going to appear to
be a year older than he really is.
ch**********@isuga.fr wrote:
这显然已经多次完成了,但是我看过的所有内容
要么难以理解,要么根本无法工作。
这对我的报告不起作用:datediff(yyyy,[DOB],现在())
这也不是:= datediff(yyyy,[DOB],现在())
有人可以提出建议吗?
那里关于如何做到这一点还有很多其他的建议,但我不能得到
任何工作。我只想在报告字段中输入年龄,基于
某人的出生日期= DOB作为字段名称。
This has apparently been done many times, but everything I''ve looked at
is either incomprehensible or simply doesn''t work.
This doesn''t work on my report: datediff("yyyy",[DOB],now())
Nor does this: =datediff("yyyy",[DOB],now())
Can anyone suggest why?
There are many other suggestions as to how to do this, but I can''t get
any to work. I just want to enter the age in a report field based on
someone date of birth = DOB as fieldname.
这篇关于年龄日期的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!