How may I change MM/DD/YYYY HH:MM:SS to epoch time?

[jsven7]

Situation:
- 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"

Problem:
- The sort command does not appear to work. I believe this is because it needs to be in epoch time to make the calculation.

Proposed Solution:
- Convert the field to epoch and run the sort command against the data set using the new epoch field.

[vnravikumar · Accepted solution]

Hi

Check this

| makeresults 
| eval "Creation Date"="03/26/2020 13:56:12" 
| eval epoch=strptime('Creation Date',"%m/%d/%Y %H:%M:%S")

[jsven7]

@vnravikumar - thank you!