I am trying to get month based on date in query report. I used Month() function.
tabDeposits.sales_partner as “Sales partner:Link/Employee:200”,
tabDeposits.delivery_date’) as “date:Link/Employee:200”,
tabDeposits.deposit_amount) as “Deposit amount::200”
GROUP BY sales_partner,MONTH(‘delivery_date’) ;
but it did not worked.
and also trying to get month from date in custom script
var d = new Date();
month = d.getMonth();
it didnt worked too… will someone please guide where i made a mistake…
thanks in advance