Parsware
All articles

Power Apps

A date range as a timeline

Two date columns, when work starts and when it ends, drawn as one bar across a fortnight with the number of days written above it.

Five of fourteen day boxes filled, with 5 days above, starting 16 November and ending 20 November

Two date boxes don’t show how long something takes. This demo draws Work starts and Work ends on a case as one bar across two weeks, with the number of days above it.

The control sits on Work starts and is bound to Work ends as its second column.

The work timeline: 5 days, five of fourteen day boxes filled, Starts 2026-11-16 and Ends 2026-11-20

Counting days

A new function, daysBetween(from, to), counts whole calendar days, so the length (both ends included) is:

daysBetween(field.value, fields.par_workends) + 1

Each of the fourteen boxes has a blue copy, shown when that length is more than its position, so the bar is as long as the job. A plain date, written 2026-11-16, is counted as that day, whatever time zone the reader is in.

A job longer than a fortnight fills every box and says Longer than two weeks underneath.

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. Work is on the Drawn controls tab; change either date on General and the bar follows.

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.