Project Server 2010 - 日期差异公式问题 - Datediff或ProjDateDiff [英] Project Server 2010 - Date Difference formula issues - Datediff or ProjDateDiff

问题描述

您好，我们正在使用Project Server 2010. 我正在尝试做什么 我认为这将是一个简单的公式，但似乎无法让它工作。 我正在尝试确定今天的日期与上次发布时间表
到服务器的日期之间的差异。  （我更喜欢工作日，但此时会接受日历日，因为工作日对我不起作用）。 我的目标是两步 - 一步，让公式给我一天计数，然后在
视图的过滤器中使用该计数。 

Hi, we are using Project Server 2010.  I am trying to do what I think will be a simple formula but can't seem to get it to work.  I am trying to determine the difference in days between today's date and the date that a schedule was last published to the server.  (I would prefer working days, but at this point will accept calendar days since working days doesn't work for me).  My goal is two step - one, to get the formula to give me a day count and then to use that count in a filter in the view. 

例如，如果今天是2011年3月30日并且时间表已于2011年3月24日发布，我希望公式告诉我不同​​的天数是6个日历日，或4个工作日。 但是，我得到以下结果。

For example, if today is 3/30/2011 and a schedule was published 3/24/2011, I expect the formula to tell me that the number of days different is 6 calendar days, or 4 working days.  However, I get the following results.

公式1：  （DateDiff（" d"，[Last Update]，Date（）））  这是项目级别，文本公式结果如下：  23

Formula 1:  (DateDiff("d", [Last Update], Date()))   which is project level, text formula results in:  23

Fromula 2：  （DateDiff（" d"，[Last Update]，Date（））） 这是项目级别，数字公式结果：23

Fromula 2:  (DateDiff("d", [Last Update], Date()))  which is project level, number formula results in: 23

公式3：ProjDateDiff（[发布日期]，[今日日期]，[项目日历]）这是项目级别，文本公式结果在：8160  （将8160除以480 [8小时乘60分]我得到17，这也是错误的。

Formula 3: ProjDateDiff([Published Date], [Todays Date], [Project Calendar]) which is project level, text formula results in: 8160  (dividing 8160 by 480 [for 8 hours by 60 minutes] I get 17, which is wrong as well.

这个公式怎么写？

推荐答案

日期（） - [最后更新]足以计算日历天数差异.ProjDateDiff（[发布日期]，[今日日期]，[项目日历]）可能正在修复正确根据日历中的工作日和运行公式
的日期来回答。

Date()-[Last Update] is enough to calculate calendar days difference. ProjDateDiff([Published Date], [Todays Date], [Project Calendar]) may be groviding teh correct answer depending on what working days there are in the calendar and the date the formula is run.

这篇关于Project Server 2010 - 日期差异公式问题 - Datediff或ProjDateDiff的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！