AnsweredAssumed Answered

CliveB

Question asked by CliveB on Dec 10, 2012
Latest reply on Dec 11, 2012 by CliveB

Title

CliveB

Post

     I need to calculate the number of days bewteen two dates using auto-enter. I have tried the following:-

Days = If((IsValid(Followup_Date) and IsValid(Start_Date)), DayofYear(Followup_Date) – DayofYear(Start_Date), “ “), however when I hit Ok I get an error message regarding the second "DayofYear"  that says this function cannot be found. Can anyone out there solve this for me.

     Kind regards

     CliveB

Outcomes