we need to check which courses were started during the month of last half a year. the code I wrote for it: "start date" - format : 2021-03-22 f "last_6_months". - calculated now()-6 month below the query we tried but its not working could you please advise? `ssdlc_base("all time back")` | where email_address!="NA" | lookup ssdlc_bu_courses.csv BU output courses | mvexpand courses | lookup ssdlc_bu_courses.csv BU courses output "start date" | rename "start date" as "start_date1" | mvexpand "start_date1" | eval start_date=strptime(strftime(start_date1,"%Y-%m-%d")."-01","%Y-%m-%d") | eval last_6_months=strptime(strftime(relative_time(now(),"-6mon"),"%Y-%m")."-01","%Y-%m-%d") | fields start_date ,last_6_months , start_date1
... View more