Forum Discussion
Solved
Make duplicate Date/time values unique
Hi,
I need to sort a name column based on Date/Time collumn.
The problem is that I have some duplicates in the Date/Time column and therefore the Sort By Collumn will fail.
To solve the issue I was wondering if you somehow can find all duplicate date/time fields and then plus 1 second to on of the fields and thatway make them unique.
Input:
| Date |
| 07/10/2021 11.33 |
| 07/10/2021 11.33 |
| 07/10/2021 16.01 |
| 12/10/2021 07.06 |
| 13/10/2021 13.23 |
| 13/10/2021 13.23 |
OutPut:
| Date sort column |
| 07/10/2021 11.33 |
| 07/10/2021 11.34 (1 added second) |
| 07/10/2021 16.01 |
| 12/10/2021 07.06 |
| 13/10/2021 13.23 |
| 13/10/2021 13.24 (1 added second) |
