
Announcements
Hi,
I was wondering if anyone has experienced this issue?
I've been trying to get the minimum date from a collection with a Min() but still retain the date formatting as well.
Min(merged, start_date), where the start date is the column of interest
Merged Table
StartDate
| 6/1/2019 |
| 8/1/2019 |
I would like to get back 6/1/2019 in the date format if possible, using a text label for illustrative purposes
Thanks!
Hi @Anonymous ,
You might need to sort your collection first.
SortByColumns(merged,"start_date",Descending)
on the Text label:
Last(merged).start_date
Thanks,
K-A-R-L
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.