Calculating time between two dates
Comments
-
Id like to add a column in my Report which calculates the time difference between two of my columns. How can I do this?
-
You can use one of our predefined Calculated Columns to get the difference between two dates.
-
Thanks! Thats helpful.
I am using the GetTimesBetween column. Is there a way to have it show the difference down to the milliseconds?
-
We can. On its properties, there is an option to specify a Custom Format. We can use it to define how we want the results to be. If you want the column to return time difference in hours, minutes, seconds, and milliseconds, please use: [color=rgb(29, 28, 29)][font=Slack-Lato, appleLogo, sans-serif]hh:mm:ss:ff[/font][/color]
[color=rgb(29, 28, 29)][font=Slack-Lato, appleLogo, sans-serif]
[/font][/color]
[img]https://i.imgur.com/fKOSU9B.png[/img]
Howdy, Stranger!
Categories
- 4.4K All Categories
- 78 General
- 13 Training
- 209 Installation / Setup
- 1.1K Flows
- 110 Rules
- 270 Administration
- 213 Portal
- 497 General Q & A
- 709 Forms
- 345 Reports
- 3 Designer Extensions
- 48 Example Flows
- 58 CSS Examples
- 1 Diagram Tile
- 7 Javascript Controls
- 186 Pages
- 5 Process Mining
- New Features
- 186 Datastructures
- 70 Repository
- 229 Integrations
- 29 Multi-Tenant
- 27 SDK
- 81 Modules
- 59 Settings
- 25 Active Directory
- 12 Version 7
- 35 Version 8
- 143 Lunch And Learn Questions