Former Member

# Help counting down to days left

I have a formula that gives me the days between 2 dates. WE have an SLA of 15 days so I need the count to go down instead of up when the report runs. So thereport would display the numbers of days left and each day that number would go down by 1 until they met or failed the sla.

##### Add a comment
10|10000 characters needed characters exceeded

### Related questions

Former Member
Posted on Aug 13, 2009 at 05:06 PM

Wouldn't you just subtract the formulated value from the SLA Example: - (datediff('d', {table.date1}, {table.date2}))

##### Add a comment
10|10000 characters needed characters exceeded
• Former Member
Posted on Aug 13, 2009 at 02:05 PM

The formula that will count the # of days between two dates is this:

datediff('d', {table.date1}, {table.date2})

I hope this helps,

Regards,

Zack H.

##### Add a comment
10|10000 characters needed characters exceeded
• Former Member Former Member

if you did something like

datediff('d', currentdate, {sla.date})

wouldn't that count your days down instead of up when you run the report each day? Assuming the SLA date you are talking about is a future date.

Zack H.