How to get unique list of dates?
Comments
-
Hi,
I have about 23K entities each of which has a date associated with it. What is the fast way of getting the unique dates for those entities?
Thanks!
-
Hello,
This is solved easily by using a Get Distinct List of Strings step and using the short date format of the dates you are using. For example, if the dates you want are under CreatedOnDate the input to that step would be under CreatedOnDate [All CreatedOnDate]>Formatting [All Formatting]>Short Date [All ShortDate]. You should then get a unique list of all of the dates from your selected entities. Let us know if you have any more questions!
Howdy, Stranger!
Categories
- 4.2K All Categories
- 67 General
- 11 Training
- 202 Installation / Setup
- 1.1K Flows
- 106 Rules
- 262 Administration
- 212 Portal
- 490 General Q & A
- 695 Forms
- 333 Reports
- 3 Designer Extensions
- 47 Example Flows
- 52 CSS Examples
- 1 Diagram Tile
- 7 Javascript Controls
- 179 Pages
- 5 Process Mining
- New Features
- 179 Datastructures
- 69 Repository
- 221 Integrations
- 28 Multi-Tenant
- 27 SDK
- 78 Modules
- 56 Settings
- 25 Active Directory
- 12 Version 7
- 35 Version 8
- 83 Lunch And Learn Questions