日期格式为yyyymmdd的Datediff [英] Datediff where date format is yyyymmdd

问题描述

帮助!! ....我需要计算两个字段之间经过的天数。

但是，日期格式是YYYYMMDD。我怎样才能完成这个？


-

Dontell Trevell


通过AccessMonster.com发布消息
http：// www。 accessmonster.com/Uwe/For...ccess/200701/1

HELP!!....I need to calculate the numer of days elapsed between two field.
But, the date format is YYYYMMDD. How can i accomplsh this?

--
Dontell Trevell

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200701/1

推荐答案

DontellTrevell写道：

DontellTrevell wrote:

> HELP !! ....我需要计算两个日期字段之间经过的天数。
但是，日期格式是YYYYMMDD。我怎样才能完成这个？

>HELP!!....I need to calculate the numer of days elapsed between two date fields.
But, the date format is YYYYMMDD. How can i accomplsh this?

-

Dontell Trevell


留言通过< a rel =nofollowhref =http://www.accessmonster.comtarget =_ blank> http://www.accessmonster.com

--
Dontell Trevell

Message posted via http://www.accessmonster.com

2007年1月31日星期三23:09:53 GMT，DontellTrevell通过AccessMonster.com

写道：

On Wed, 31 Jan 2007 23:09:53 GMT, DontellTrevell via AccessMonster.com
wrote:

HELP !! ....我需要计算两个字段之间经过的天数。

但是，日期格式是YYYYMMDD。我怎么能完成这个？

HELP!!....I need to calculate the numer of days elapsed between two field.
But, the date format is YYYYMMDD. How can i accomplsh this?

2个字段的数据类型是什么？

如果两者都是Date数据类型，那么只需从另一个数据类型中减去一个。

字段的格式无关紧要。

[DaysDifference] = [Date2] - [Date1]


-

Fred

请回复此新闻组。

我不回复个人电子邮件

What are the 2 fields datatypes?
If both are Date datatypes, then simply subtract one from the other.
The Format of the field is irrelevant.
[DaysDifference] = [Date2] - [Date1]

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

fredg写道：

fredg wrote:

> HELP !! ....我需要计算两个字段之间经过的天数。但是，日期格式为YYYYMMDD。我怎么能完成这个？

>HELP!!....I need to calculate the numer of days elapsed between two field.
But, the date format is YYYYMMDD. How can i accomplsh this?

2个数据类型是什么？
如果两个数据类型都是Date数据类型，那么只需从另一个数据类型中减去一个。
字段的格式无关紧要。
[DaysDifference] = [Date2] - [Date1]

What are the 2 fields datatypes?
If both are Date datatypes, then simply subtract one from the other.
The Format of the field is irrelevant.
[DaysDifference] = [Date2] - [Date1]

非常感谢!!!!我不知道那很简单...... DontellTrevell


-

Dontell Trevell


通过AccessMonster.com发布的消息
http://www.accessmonster.com/Uwe/For...ccess/200702/1

Thank You very much!!!! I did''nt know it was that simple.....DontellTrevell

--
Dontell Trevell

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200702/1

这篇关于日期格式为yyyymmdd的Datediff的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！