Sharepoint 2013计算字段中的EDATE错误 [英] EDATE Error in Sharepoint 2013 Calculated Field

问题描述

背景:我创建了一个工作流程，以在每个已知日期(关闭)和(转换)之间的每个月的同一日期发送通知.在SPD 2013中，我使用了添加时间到日期功能，但是添加一个月实际上只增加了30天，而没有 占了几个月或更少或几天的时间，因此不得不寻找替代解决方案.

Background:  I created a workflow to send notifications on the same date of each month between two known dates (close) and (cutover).  In SPD 2013, I used the add time to date function but adding one month really only adds 30 days and does not account for months with less or more days so had to find an alternate solution.  

我返回到SP 2013列表，以创建一个新字段来计算下一个要根据计算出的日期运行工作流的通知日期.

I resorted back to the SP 2013 list to create a new field to calculate the next notification date intending to run the workflow based off the calculated date.

使用EDATE时出现错误.

When I use EDATE, I get an error.  

我的结束日期设置为日期"，我尝试先将新的计算字段设置为日期"，然后再设置日期"和日期".时间，但继续出现错误，这将使我什至无法创建该字段.

My close date is set as Date and I have tried setting up the new calculated field first as date and then date & time but continue to get an error that will not allow me to even create the field.  

关于如何解决此问题的任何建议?

Any suggestions on how to fix this?

谢谢.

推荐答案

艾琳，您能提供屏幕截图或正在使用的计算吗?您可能想要尝试将日期输入到您所计算列的文本框中.

Hi Erin- could you provide screen shots or the calculation you're using? You may want to try to input the dates into text boxes for your calculated column.

这篇关于Sharepoint 2013计算字段中的EDATE错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！