计算的列结果...在列表视图中显示正常，但在工作流中不显示 [英] Calculated column result... Displaying okay in List View but not in Workflow
问题描述
我创建了一个列来计算下一个到期日.因此，在此示例中，用户填写新表格，然后选择每月".重复执行任务并进行以下计算
I have created a column to calculate the next due date. So in this example, the user completes the new form, selects "Monthly" as the Task Recurrance and the following calculation happens
IF([Task Recurrance]="Monthly",IF(WEEKDAY(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])),2)=1,CONCATENATE(TEXT(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])),"d/MM/yyyy")," ",TEXT([Start Date],"hh:mm AM/PM")),IF(WEEKDAY(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])),2)=2,CONCATENATE(TEXT(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])),"d/MM/yyyy")," ",TEXT([Start Date],"hh:mm AM/PM")),IF(WEEKDAY(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])),2)=3,CONCATENATE(TEXT(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])),"d/MM/yyyy")," ",TEXT([Start Date],"hh:mm AM/PM")),IF(WEEKDAY(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])),2)=4,CONCATENATE(TEXT(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])),"d/MM/yyyy")," ",TEXT([Start Date],"hh:mm AM/PM")),IF(WEEKDAY(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])),2)=5,CONCATENATE(TEXT(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])),"d/MM/yyyy")," ",TEXT([Start Date],"hh:mm AM/PM")),IF(WEEKDAY(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])),2)=6,CONCATENATE(TEXT(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])+2),"d/MM/yyyy")," ",TEXT([Start Date],"hh:mm AM/PM")),IF(WEEKDAY(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])),2)=7,CONCATENATE(TEXT(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])+1),"d/MM/yyyy")," ",TEXT([Start Date],"hh:mm AM/PM")),0)))))))或
IF([任务重复发生次数] =每月"，IF(WEEKDAY(DATE(YEAR([开始日期])，MONTH([开始日期])+ 1，DAY([开始日期]))，2) = 1，CONCATENATE(TEXT(DATE(YEAR([开始日期]]，MONTH([开始日期])+ 1，DAY([开始日期]))，"d/MM/yyyy")，" ，TEXT([开始 日期]，"hh:mm AM/PM"))，IF(WEEKDAY(DATE(YEAR([开始日期]]，MONTH([开始日期])+ 1，DAY([开始日期]))，2) = 2，CONCATENATE(TEXT(DATE(YEAR([开始日期]]，MONTH([开始日期])+ 1，DAY([开始日期]))，"d/MM/yyyy")，" ，TEXT([开始日期]，"hh:mm AM/PM))，IF(WEEKDAY(DATE(YEAR([开始日期]))，MONTH([开始日期])+ 1，DAY([开始日期]))，2)= 3，CONCATENATE(TEXT(DATE (YEAR([开始日期])，MONTH([开始日期])+ 1，DAY([开始日期]))，"d/MM/yyyy")，"，TEXT([开始日期]， "hh:mm AM/PM"))，IF(WEEKDAY(DATE(YEAR([Start 日期])，MONTH([开始日期])+ 1，DAY([开始日期]))，2)= 4，CONCATENATE(TEXT(DATE(YEAR([开始日期]))，MONTH([开始日期])+ 1，DAY([开始日期]))，"d/MM/yyyy")，"，TEXT([开始日期]，"hh:mm AM/PM"))，IF(WEEKDAY(DATE (YEAR([开始日期])，MONTH([开始 日期])+ 1，DAY([开始日期]))，2)= 5，CONCATENATE(TEXT(日期(YEAR([开始日期])，MONTH([开始日期])+ 1，DAY([开始日期] ))，"d/MM/yyyy")，，TEXT([开始日期]，"hh:mm AM/PM"))，IF(WEEKDAY(DATE(YEAR([开始日期])) ，MONTH([开始日期])+ 1，DAY([开始 Date]))，2)= 6，CONCATENATE(TEXT(DATE(YEAR([开始日期]]，MONTH([开始日期])+ 1，DAY([开始日期])+ 2)，'d/MM /yyyy")，"，TEXT([开始日期]，"hh:mm AM/PM"))，IF(WEEKDAY(DATE(年([开始日期]])，MONTH([开始日期]) + 1，DAY([开始 Date]))，2)= 7，CONCATENATE(TEXT(DATE(YEAR([开始日期]]，MONTH([开始日期])+ 1，DAY([开始日期])+ 1)，"d/MM /yyyy)，"",, TEXT([开始日期]，" hh:mm AM/PM))，0))))))))))))
IF([Task Recurrance]="Monthly",IF(WEEKDAY(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])),2)=1,CONCATENATE(TEXT(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])),"d/MM/yyyy")," ",TEXT([Start Date],"hh:mm AM/PM")),IF(WEEKDAY(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])),2)=2,CONCATENATE(TEXT(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])),"d/MM/yyyy")," ",TEXT([Start Date],"hh:mm AM/PM")),IF(WEEKDAY(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])),2)=3,CONCATENATE(TEXT(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])),"d/MM/yyyy")," ",TEXT([Start Date],"hh:mm AM/PM")),IF(WEEKDAY(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])),2)=4,CONCATENATE(TEXT(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])),"d/MM/yyyy")," ",TEXT([Start Date],"hh:mm AM/PM")),IF(WEEKDAY(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])),2)=5,CONCATENATE(TEXT(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])),"d/MM/yyyy")," ",TEXT([Start Date],"hh:mm AM/PM")),IF(WEEKDAY(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])),2)=6,CONCATENATE(TEXT(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])+2),"d/MM/yyyy")," ",TEXT([Start Date],"hh:mm AM/PM")),IF(WEEKDAY(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])),2)=7,CONCATENATE(TEXT(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])+1),"d/MM/yyyy")," ",TEXT([Start Date],"hh:mm AM/PM")),0)))))))
因此，在列表视图中，该列将按预期显示为日期...
So, in the List View, the column is displaying as the date as expected...
但是当我在工作流程中引用此列时，它返回为01/01/0001(下面仅使用Log操作)
But when I reference this column in the workflow, it is coming back as 01/01/0001 (below is just using the Log action)
有人能看到我所缺少的东西吗?
Can anybody see anything I'm missing?
推荐答案
* bump *这正成为一个问题，因为它正在影响我们生产环境...我注意到，如果我仅使用一个连接来放入一个CALC，它可以工作，但不止一个，并且工作流不喜欢它...
*bump* this is becoming an issue now as it is affecting our production environment... I notice if I only put in one CALC using the concatenate it works but more than one and the workflow doesn't like it...
例如，这将起作用(= 3仅一个条目)
For example, this will work (only one entry for =3)
= IF([任务重复发生次数] =每月"，IF(WEEKDAY([开始日期]，2)= 1，[开始日期] + 1，IF(WEEKDAY([开始日期]，2)= 2 ，[开始日期] + 1，IF(WEEKDAY(DATE(YEAR([开始日期]))，MONTH([开始日期])+ 1，DAY([开始日期]))，2)= 3，CONCATENATE(TEXT( DATE(YEAR([开始 日期])，MONTH([开始日期])+ 1，DAY([开始日期]))，"d/MM/yyyy")，"" TEXT([开始日期]，"hh:mm AM/PM"))，IF(WEEKDAY([开始日期]，2)= 4，[开始日期] + 1，IF(WEEKDAY([开始日期]，2)= 5，[开始日期] + 3，IF(WEEKDAY([开始日期]，2)= 6，[开始 日期] + 2，IF(WEEKDAY([开始日期]，2)= 7，[开始日期] +1,0)))))))))))
=IF([Task Recurrance]="Monthly",IF(WEEKDAY([Start Date],2)=1,[Start Date]+1,IF(WEEKDAY([Start Date],2)=2,[Start Date]+1,IF(WEEKDAY(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])),2)=3,CONCATENATE(TEXT(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])),"d/MM/yyyy")," ",TEXT([Start Date],"hh:mm AM/PM")),IF(WEEKDAY([Start Date],2)=4,[Start Date]+1,IF(WEEKDAY([Start Date],2)=5,[Start Date]+3,IF(WEEKDAY([Start Date],2)=6,[Start Date]+2,IF(WEEKDAY([Start Date],2)=7,[Start Date]+1,0)))))))
但是，如果我为= 4添加一个附加值，则= 3将起作用，但= 4将不会起作用...
But if I add an additional one for =4, the =3 will work but the =4 will not...
= IF([任务重复发生次数] =每月"，IF(WEEKDAY([开始日期]，2)= 1，[开始日期] + 1，IF(WEEKDAY([开始日期]，2)= 2 ，[开始日期] + 1，IF(WEEKDAY(DATE(YEAR([开始日期]))，MONTH([开始日期])+ 1，DAY([开始日期]))，2)= 3，CONCATENATE(TEXT( DATE(YEAR([开始
日期])，MONTH([开始日期])+ 1，DAY([开始日期]))，"d/MM/yyyy")，"" TEXT([开始日期]，"hh:mm AM/PM"))，IF(WEEKDAY(DATE(YEAR([开始日期])，MONTH([开始日期])+ 1，DAY([开始日期]))，2)= 4，CONCATENATE(TEXT(DATE(YEAR([开始日期]))，MONTH([开始
日期])+ 1，DAY([开始日期]))，"d/MM/yyyy")，"" TEXT([开始日期]，"hh:mm AM/PM"))，IF(WEEKDAY([开始日期]，2)= 5，[开始日期] + 3，IF(WEEKDAY([开始日期]，2)= 6，[开始日期] + 2，IF(WEEKDAY([开始日期]，2)= 7，[开始日期] +1,0))))))))))))))
=IF([Task Recurrance]="Monthly",IF(WEEKDAY([Start Date],2)=1,[Start Date]+1,IF(WEEKDAY([Start Date],2)=2,[Start Date]+1,IF(WEEKDAY(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])),2)=3,CONCATENATE(TEXT(DATE(YEAR([Start
Date]),MONTH([Start Date])+1,DAY([Start Date])),"d/MM/yyyy")," ",TEXT([Start Date],"hh:mm AM/PM")), IF(WEEKDAY(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])),2)=4,CONCATENATE(TEXT(DATE(YEAR([Start Date]),MONTH([Start
Date])+1,DAY([Start Date])),"d/MM/yyyy")," ",TEXT([Start Date],"hh:mm AM/PM")),IF(WEEKDAY([Start Date],2)=5,[Start Date]+3,IF(WEEKDAY([Start Date],2)=6,[Start Date]+2,IF(WEEKDAY([Start Date],2)=7,[Start Date]+1,0)))))))
我唯一能改变的就是SharePoint已于2017年4月修补到CU.
The only thing I can think that has changed is that SharePoint was patched to CU April 2017 recently.
这篇关于计算的列结果...在列表视图中显示正常，但在工作流中不显示的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
