Parsware
All articles

Power Apps

An SLA countdown

“2 days left”, turning amber three days out and red once the case is late: a due date as a countdown, with today() and daysBetween().

2 days left in large letters beside an amber stripe, due 17 November

A due date says when. A countdown says how worried to be. This demo draws a case’s Due date as days left, with a coloured stripe that turns amber three days out and red once it’s late.

2 days left, with an amber stripe and Due 2026-11-17

Two new functions

today() is today as a calendar day, and daysBetween(from, to) counts whole days between two dates, going negative once the second is past. The days left are:

daysBetween(today(), field.value)

The headline picks its words from that number, 2 days left, 1 day left, Due today, or Late by 3 days, and three stripes, green, amber and red, are each shown for their range.

Late by 3 days with a red stripe, due 2026-11-12

Both functions count calendar days in the reader’s own time zone, so 11pm tonight and 1am tomorrow are one day apart. Reports have the same two functions, so an overdue list means the same thing on paper.

Try it

  1. Install the three Parsware for Power Apps solutions, samples included (Install it).
  2. Open Sample data and press Replace, so the newest columns are filled (The samples, and sample data).
  3. Open a case. Due is on the Drawn controls tab. The sample due dates are set from the day you fill them.

The pictures show the shipped design running on demo data in Parsware’s own runtime. In Power Apps the form, the side pane and the dialog are the app’s own.