asked on August 1, 2018

I am creating Project Request submission form. I want to calculate the project duration by using DATEDIF formula on "Start Date" and "Finish Date" date fields. I positioned all three fields into section and called it "Expected Duration" and creating the following formula:

=DATEDIF(Project_Duration.Start_Date_Value,Project_Duration.Finish_Date_Value,"m")

I also tried FLOOR formula as follow:

=FLOOR((Project_Duration.Finish_Date_Value-Project_Duration.Start_Date_Value)/365.25,1)&"year(s),"&FLOOR(MOD((Project_Duration.Finish_Date_Value-Project_Duration.Start_Date_Value)/365.25,1)*12,1)&"month(s),"&FLOOR(MOD((Project_Duration.Finish_Date_Value-Project_Duration.Start_Date_Value)/30.4375,1)*30.4375,1)&"day(s)"

 

In both cases i receive an error stating that the formula contains referencing errors and then it references the variables associated with the date fields. I checked the variables names and everything seems to be fine. I would appreciate if anyone can help troubleshoot this error. Thanks.

test.png
test.png (14.24 KB)
0 0