ERPNext.com Frappe Cloud Support Partners Foundation Frappe School

DATE_FORMAT issue in Query Reports

Hi guys, i have been working on Query Reports on Frappe, and not able to format the date within Query Report that i made, the Query is

Select DATE_FORMAT(SO_I.modified, ‘%m/%d/%Y %H:%i’) as “SO Item Modified::120” from tabSales Order Item SO_I;

This query is correctly running within MariaDB

06/30/2021 17:29

but gives error in Frappe

ValueError: unsupported format character 'm' (0x6d) at index 36

and ( date_format(inv.creation, “%%Y-%%m-%%d”) between %(fecha_inicial)s and %(fecha_final)s )

Thanks, this worked for me

Select date_format(SO_I.modified, ‘%%m-%%d-%%Y %%H:%%i’) as “SO Item Modified::120” from tabSales Order Item SO_I;