MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

DateDif function not working

  Asked By: Joseph    Date: Aug 09    Category: MOSS    Views: 3652

in my Sharepoint list I created a calculated column to give me the difference
between two date columns. My formula is =DATEDIF([Due Date],[Quote Added],"D").
For some reason it is not working; it is showing "#NUM!". I'm not sure what I'm
doing wrong. Both of the date columns are set to date/time type, date only and
have valid dates entered. 8/25/2010 and 8/16/2010.

Any ideas on this?



3 Answers Found

Answer #1    Answered By: Sandra Alexander     Answered On: Aug 09

Is the result less than zero? It looks like that might be the case based on
the order in which you've listed the dates here. If so, then you probably
want to add a condition; see the following forum thread for details:


Answer #2    Answered By: Nalin Rao     Answered On: Aug 09

Apparently SP doesn't want to play nice if the days are negative.
I had my dates in the wrong order.

Answer #3    Answered By: Thomas Davis     Answered On: Aug 09

Yeah, you'd think a signed integer would be appropriate for the result;
apparently that wouldn't be cryptic enough

Didn't find what you were looking for? Find more on DateDif function not working Or get search suggestion and latest updates.