- I have some records with a human readable field "Creation Date" (MM/DD/YYYY HH:MM:SS).
- I'd like to sort by "Creation Date"
- The sort command does not appear to work. I believe this is because it needs to be in epoch time to make the calculation.
- Convert the field to epoch and run the sort command against the data set using the new epoch field.
| eval "Creation Date"="03/26/2020 13:56:12"
| eval epoch=strptime('Creation Date',"%m/%d/%Y %H:%M:%S")
View solution in original post
@vnravikumar - thank you!