Difference between dates, BUT if 0 should output "0 days" and not just leave blank #1384
-
|
Continuing the discussion from How to Calculate Duration between Dates in Dataview:
This works great, but if the result is 0 I get a blank. I'm not using this for ages but for the length of time it takes to read a book, so sometimes I have a difference of 0, but I'd like it to say that instead of just leaving a blank. I've tried Any ideas? |
Beta Was this translation helpful? Give feedback.
Replies: 1 comment 3 replies
-
|
I figured that out :) I now have Now I'd just like to know if there's a way to have the resulting date be shown as only days, not months, weeks, days? |
Beta Was this translation helpful? Give feedback.
-
|
Extract days with |
Beta Was this translation helpful? Give feedback.
-
|
That worked, thanks! Apologies for the question if it was stated in the docs, I've been having trouble with those. The search function doesn't always work for me, and as I don't know any programming I also don't always know what to search for. Thanks though! |
Beta Was this translation helpful? Give feedback.
-
|
Hmm I'll check that out. No shade on you, was a genuine question to make sure people find it accessible. |
Beta Was this translation helpful? Give feedback.
I figured that out :) I now have
choice((DateFinished != DateStarted), DateFinished - DateStarted, "0 days" )so that it only does the math IF the start and end date aren't already the same.Now I'd just like to know if there's a way to have the resulting date be shown as only days, not months, weeks, days?