I have data in a CSV file like:
Name. dob gender
Xxx 02/08/1995 m
Abc 12/09/1993 F
Bxc 24/05/1992 m
So I need to monitor this Excel and using alerts, I should trigger an email by comparing today's date and dob and should trigger an email with user name and description with a happy birthday message.
Can someone ping the sample search for this?
We will compare month and date not the year
| inputlookup doblist.csv | eval birthday=strptime(dob, "%m/%d") | eval today=relative_time(now(), "@d") | where dob=today
View solution in original post
Can you please follow up with your question and confirm if the answer by @sundareshr solved your question? If yes, please be sure to resolve the post by clicking "Accept" directly below his answer. Thanks!