Hi, I have seen a few post on this subject, but none seem to fix my issue. I am trying to calculate the difference between two date/time stamps. | eval CompleteDate=if(isnull(CompleteDate) OR len(CompleteDate)==0,strftime(now(),"%Y-%m-%d %H:%M:%S:%7Q"),CompleteeDate) |eval Start = strptime(AwaitingResponseDate,"%Y-%m-%d %H:%M:%S:%7Q") |eval End = strptime(CompleteDate,"%Y-%m-%d %H:%M:%S:%7Q") |eval WaitTime = Start-End The issue seems to be that the Start field is empty when i add it to a table, however, the End time works. The only difference between start and end is that end is being set by the eval/if statement for CompleteDate because all are null. Start/AwaitingResponseDate is an auto extracted field The date/time format is the same for each filed. This is an example of the AwaitingResponseDate value 2020-07-20 18:35:15.0000000 This is an example of the inserted CompleteDate field from the same record 2020-08-19 09:19:53:0000000 Any help is certainly appreciated.
... View more