Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Help with date

Hi,   im trying to calculate the number of days an item is opened. (Attached below)   If Column A is Blank, Column B should show the number of days an item is opened for   However if column A h...
Show and Tell
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , Try a new column like

    if(isblank([A]), datediff([date creation],today(), day), 0)

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , Try a new column like

if(isblank([A]), datediff([date creation],today(), day), 0)

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Worked. Thank you