I have created a date (yyyy/mm/dd) column called "Initialdatesigned" in my lookup table. This table also contains the account name column along with the initialdatesigned. I would like to filter my query to look for accounts in the lookuptable where it only displays accounts signed within the last 30 days.
I tried to search in sumologic articles but was unable to find the right solution.
| Lookup accountname,initialdatesigned from path: xyz on account=accountname
| where initialdatesigned < (initialdatesigned,-30d) //the goal
Any help will be highly appreciated!
Please sign in to leave a comment.