Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi - How to use first sorted value on date format which has time also ? Ex. Below
Amount | Date |
1000 | 07/26/2021 1:35:00 PM |
2000 | 07/26/2021 1:33:00 PM |
Result would be $1000.
Thank you.
Internally, a Timestamp is just a number with a fraction. So the value can be used for ordering just like an integer.
FirstSortedValue(Amount, -Date)
-Rob
I tried that but did not work. So converted date to numeric value and did firstsort on that. Thank you much.