Calculating the days between two dates in a report
Comments
-
Hello,
I have a report and would like to display the days between dates, but when I do it, the days end up as 0. My two dates are 7/30 and 7/31. Do you have a solution for this? -
Thanks for the question.
Presumably due to rounding. If youre using dates that are close together like that, you might be better off using the "calculate hours" instead. Also, you could also look into running some sort of filter that divides this time by 24 to get you the "days" youre looking for. However, keep in mind this can be very intensive if your report is very large.
Howdy, Stranger!
Categories
- 4.1K All Categories
- 61 General
- 11 Training
- 201 Installation / Setup
- 1.1K Flows
- 106 Rules
- 260 Administration
- 212 Portal
- 489 General Q & A
- 693 Forms
- 333 Reports
- 3 Designer Extensions
- 47 Example Flows
- 51 CSS Examples
- 1 Diagram Tile
- 7 Javascript Controls
- 178 Pages
- 5 Process Mining
- New Features
- 178 Datastructures
- 69 Repository
- 219 Integrations
- 28 Multi-Tenant
- 27 SDK
- 76 Modules
- 56 Settings
- 25 Active Directory
- 12 Version 7
- 35 Version 8
- 66 Lunch And Learn Questions