Odoo Help


end date display in rml report only passing start date

on 5/8/13, 1:41 AM 1,084 views

sql="""select he.name_related, he.lead_target, count(cl.user_id) as achieved, round(((cast(count(cl.user_id) as decimal(2))/he.lead_target)*100)) as val from crm_lead cl, hr_employee he, res_users rs, resource_resource rr where cl.type='opportunity' and rr.id=he.resource_id and rs.id=rr.user_id and rs.id=cl.user_id and date_open>='%s' and date_open<=date_open + interval '7 days' group by he.name_related, he.lead_target """ %(form['start_date'])------------------>i am passing only start date i need to get the interval date as a end date, above query is working fine <blocktable colwidths="530.00" style="table1">
<para style="terp_tblheader_Details">Date from: [[ data['form']['start_date'] ]] to [[here how to get the end date from the start of perticular interval]]</para>

On 5/8/13, 7:25 AM

i used function and calculate the end date and pass to the report

Looking for the same, please elaborate more.

on 8/16/13, 10:08 AM

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

0 follower(s)


Asked: 5/8/13, 1:41 AM
Seen: 1084 times
Last updated: 3/16/15, 8:10 AM