Hello All,
I Have a field "Due Date" that has dates in different formats like "08-09-2017 12:00" or "8/17/2017 12:59 PM".I have to find the difference between the current date and "Due date".For this i need to convert "Due Date" field to epoch(which iam unable to do).
When i try 'strptime' command,it doesnt show any values.When i use 'strftime' command like below,although the current date is getting converted,the field 'Due Date' doesnt get converted at all.
eval timenow=now() | eval ns=strftime(timenow,"%m-%d-%Y %H:%M %p") | eval ds=strftime('Due Date',"%m-%d-%Y %H:%M %p") | eval diff='Due Date' - ns.
Please suggest how can i convert "Due Date" field that has dates in different formats to epoch and find the difference?
Thanks,
Navya
... View more