Logo 
Search:

MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

Calculated date field issue

  Asked By: Shauna    Date: Aug 19    Category: MOSS    Views: 1231

We are calculating two date fields. however one is a start date the other is a
stop date. Our issue is the stop date seldom have a value until the stop date
has arrived and entered. So until the stop date the column returns #NUM! How
can we suppress the value of #NUM!?

Formula is currently =DATEDIF([Nexavar start date],[Nexavar Stop Date],"d")

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Adya Deshmane     Answered On: Aug 19

Well we did figure out the needed string(s).

=IF(NOT(ISNUMBER([Nexavar start date])),"",IF(NOT(ISNUMBER([Nexavar Stop
Date])),"",DATEDIF([Nexavar start date],[Nexavar Stop Date],"d")))

This page helped greatly!

msdn.microsoft.com/en-us/library/bb862071.aspx

 
Didn't find what you were looking for? Find more on Calculated date field issue Or get search suggestion and latest updates.




Tagged: