duration in days, not as date?

  • Thread starter Thread starter Karel
  • Start date Start date
K

Karel

I want to make a field that displays the duration between
2 dates. I used the folowing rule for this : CVDate([Date
of Closure]-[Date of Open]), where "Date of Closure"
and "Date of Open" are 2 other fields in the same query.
But, when the duration is longer then 1 day, it displays
it as follows: 02/01/1900 00:00:04. How can I make it so
that it just displays the number of days and the time?
(like: 2days 00:00:04 or something likely).
Thx in advance

Karel
 
-----Original Message-----
I want to make a field that displays the duration between
2 dates. I used the folowing rule for this : CVDate ([Date
of Closure]-[Date of Open]), where "Date of Closure"
and "Date of Open" are 2 other fields in the same query.
But, when the duration is longer then 1 day, it displays
it as follows: 02/01/1900 00:00:04. How can I make it so
that it just displays the number of days and the time?
(like: 2days 00:00:04 or something likely).
Thx in advance

Karel
.
Click to expand...

Hi Karel,

Not sure if this will give you the desire result but you
could you the following formula or similar.

Format ( your code ,"d")

or use Date Diff function - Help will give examples. i'm
sure you can use Format in conjunction with date diff
also.

regards,
matt
 
Back
Top