I'm trying to construct a report that's to the value start date between the first and the last date of the current month. I know that I can do this through a filter but I'd like it to be coded so that I can ahve it be emailed
list Report_Example
{
displayname = "Report Example"
#show
(for each TimeSheet in Time_Sheet [Start_Time > zoho.currentdate])
(
Employee_Details as "Employee"
New_Company as "Client"
New_Project as "Project"
Start_Time as "Start Time"
End_Time as "End Time"
Duration
Task_Description as "Task Description"
Billable as "Billed"
January_Hours as "January Hours- Fractions"
)
group by
(
Employee_Details ascending
)
sort by
(
New_Company ascending
New_Project ascending
January_Hours ascending
)
}
As you can see, I'm attempting in the For Each line to accomplish this task but I'm finding the deluge scripting tutorials/help a bit lacking. Any help in this would be greatly appreciated.