Forum Discussion

RvdHeijden's avatar
RvdHeijden
Post Prodigy
9 years ago

DateDiff with a BLANK value

I have a question about a 'simple' datediff formula.   Ive got 2 date values and i need to know the difference between them. At first this is a simple question if both colums have values. But some...
Need Help
vanessafvg's avatar
vanessafvg
Community Champion
9 years ago

RvdHeijden or you could say

 

test column =
IF ( startdate < enddate, DATEDIFF ( startdate, enddate, DAY ), BLANK () )

 

or

 

test column =
IF ( ISBLANK ( enddate ), BLANK (), DATEDIFF ( startdate, enddate, DAY ) )

  • RvdHeijden's avatar
    RvdHeijden
    Post Prodigy
    9 years ago

    vanessafvg

    if i understand your formula it doesn't return a value if the enddate is BLANK right ?

    My question was that IF the enddate is BLANK it should use TODAY to fill in the blank Enddate

    • vanessafvg's avatar
      vanessafvg
      Community Champion
      9 years ago

      RvdHeijden

       

      test =
      IF (
          ISBLANK ( enddate ),
          DATEDIFF ( startdate, TODAY (), DAY ),
          DATEDIFF ( startdate, enddate, DAY )
      )

       

      yep sorry missed that

      • RvdHeijden's avatar
        RvdHeijden
        Post Prodigy
        9 years ago

        vanessafvg

        That seems to work better but i just have 2 more questions

         

        1. If the 'begindate' = 'enddate' it returns 0 but it should return 1, can i just +1 in the formula ?

        2. i want it to calculate using workdays (sorry i didn't mention it the first time)

            i have a 'Date' table and a colum 'IsWorkday' with value 0 and 1