Help with script to generate monthly backup report using Azure monitor

Hi azurenewb1984 

I can help with a) by using the make_datetime() function:

let dt = datetime_add("month",-1,now()); 
let year= datetime_part("year",dt);
let month = datetime_part("month",dt);
let startmonth = make_datetime(year,month,1,0,0,0);
let endmonth = datetime_add("month",1,startmonth);
print year,month,startmonth,endmonth

Benoit