Unanswered: Help! Calculate difference b/w Dates (auto-input today if Enddate=Null)
Sorry for the novice question. I am trying to find a datediff() function that returns the amount of days between a startdate [SAC Join Date] and enddate [Drop Date], or would calculate the startdate and today if the enddate was blank, to a number field. I'm sure there is a pretty easy answer. I would try to have prettier code, but I'm totally lost and my newness for working with the datediff function is clearly showing. I've spend hours searching, and can't seem to find the answer. Thanks for the help.