Help

Hide negative integer when using DATETIME_FORMAT

1358 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Nora_Kramer
4 - Data Explorer
4 - Data Explorer

I am trying to calculate the number of dates between when a project came in house and today’s date, so I can show how many days it has been in house. I am using the following formula, which works well. But, of course it results in a negative number of days, since the in date it came in is lower than today’s date. So for instance, if a project came in on 12/01 and today is 12/05, I would like it to show 4 days in house, not “-4”. Is there a way to suppress the negative symbol and just output the 4?

DATETIME_DIFF({Request Date}, TODAY(), ‘days’)

^^ That is the function I am currently using

2 Replies 2

Hi @Nora_Kramer - just flip them around:

DATETIME_DIFF(TODAY(), {Request Date}, 'days')

:slightly_smiling_face:

JB

Oh my gosh! :woman_facepalming: Brilliant! Der…why did’t I think of that. Worked great!