I want to generate a query report between two date but where clause didn’t work,Please guide me , I am using mysql
select tabSales Invoice
.Name,
tabSales Invoice
.Posting_Date,
tabSales Invoice
.Debit_to,
tabSales Invoice
.rounded_total
from tabSales Invoice
,
tabSales Invoice Item
Where tabSales Invoice
.name= tabSales Invoice Item
.parent
and tabSales Invoice
.Posting_Date >=“01-01-2012”
–
You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.
To post to this group, send email to er...@googlegroups.com.
To unsubscribe from this group, send email to erpnext-developer-forum+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/RoxaW_Vn7UYJ.
For more options, visit https://groups.google.com/groups/opt_out.
rmehta
#2
use posting date as yyyy-mm-dd
On 27-Dec-2012, at 10:01 AM, Stk Intl Trading IT Manager Mahr Haider <
st...@gmail.com> wrote:
I want to generate a query report between two date but where clause didn't work,Please guide me , I am using mysql
select `tabSales Invoice`.Name,
`tabSales Invoice`.Posting_Date,
`tabSales Invoice`.Debit_to,
`tabSales Invoice`.rounded_total
from `tabSales Invoice`,
`tabSales Invoice Item`
Where `tabSales Invoice`.name= `tabSales Invoice Item`.parent
and `tabSales Invoice`.Posting_Date >="01-01-2012"
–
You received this message because you are subscribed to the Google Groups “ERPNext Developer Forum” group.
To post to this group, send email to er…@googlegroups.com.
To unsubscribe from this group, send email to erpnext-developer-forum+un…@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/RoxaW_Vn7UYJ.
For more options, visit https://groups.google.com/groups/opt_out.
–
You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.
To post to this group, send email to er...@googlegroups.com.
To unsubscribe from this group, send email to erpnext-developer-forum+un...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
On Thursday, 27 December 2012 08:31:15 UTC+4, Stk Intl Trading IT Manager Mahr Haider wrote:
I want to generate a query report between two date but where clause didn’t work,Please guide me , I am using mysql
select tabSales Invoice
.Name,
tabSales Invoice
.Posting_Date,
tabSales Invoice
.Debit_to,
tabSales Invoice
.rounded_total
from tabSales Invoice
,
tabSales Invoice Item
Where tabSales Invoice
.name= tabSales Invoice Item
.parent
and tabSales Invoice
.Posting_Date >=“01-01-2012”
–
You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.
To post to this group, send email to er...@googlegroups.com.
To unsubscribe from this group, send email to erpnext-developer-forum+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/HdXZjPI-GccJ.
For more options, visit https://groups.google.com/groups/opt_out.