Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Custom Column - Add condition to date calculation

Hi All,   I have a custom column which gives the duration of problem ticket records from when they are open to when they are closed ([closed_date]-[created_date]).   However, as some of the ticke...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi shaowu459  and PhilipTreacy,

     

    Apologies for the delayed response.  I wanted to thank you both; though the formulae you both provided did not quite work for me, I was able to work it out using your examples by snipping out this part:

     

    = if [closed_date]=null then DateTime.LocalNow()-[created_date] else [closed_date]-[created_date]

     

    Thanks to each of you for pointing me in the right direction! 🙂

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi shaowu459  and PhilipTreacy,

 

Apologies for the delayed response.  I wanted to thank you both; though the formulae you both provided did not quite work for me, I was able to work it out using your examples by snipping out this part:

 

= if [closed_date]=null then DateTime.LocalNow()-[created_date] else [closed_date]-[created_date]

 

Thanks to each of you for pointing me in the right direction! 🙂