Hi I want to pull from the form "Job" and find the number of warranties in the given month.  The underlined portion is what i need. On the job form I have a field called Date Received. I want the deluge script to count all records from the current month with the job number than contains W. I can do this via records however this script runs daily and need to do it from deluge.

thanks

Jobs_Day_Count = Job[Job_Status == "Approved" || Job_Status == "In Queue" || Job_Status == "In Progress" || Job_Status == "In Progress On Hold" || Job_Status == "Waiting for Parts" || Job_Status == "Parts Received" || Job_Status == "Waiting for Customer Info" || Job_Status == "Info Received" || Job_Status == "Repaired On Hold" || Job_Status == "Manager Input Required" && Code != "Test Equipment" && Code != "Manufacture"].count();

info "Jobs = " + Jobs_Day_Count;

info "Month = " + zoho.currenttime.getMonth();

info "Warranties = " + Warranty_Day_Count;

insert into Approved_Jobs_Not_Completed_Per_Day

[

Added_User=zoho.loginuser

Approved_Not_Completed_Jobs=Jobs_Day_Count

Warranty_Jobs = 0

Date_field=today

]