Hi, I have been able to solve the problem with this query:
index=main auditSource=for-frontend auditType=FormSaved
| eval generatedAt=strptime(generatedAt, "%Y-%m-%dT%H:%M:%S")|convert timeformat="%d/%b/%Y" ctime(generatedAt)
| rename generatedAt As "submissiondate"
| eval testtime=relative_time(now(), "-10m@m" )
| eval c_time=strftime(testtime,"%d/%b/%Y")
| where c_time<=submissiondate
| search NOT[search index=main auditSource=for-frontend auditType=FormSubmission
| table detail.referenceNumber]
| table detail.referenceNumber submissiondate c_time
Many thanks and kindest regards
Chris
... View more