Sql syntax on report

ERPNext
1

I am trying to bulid report and here it sounds like I mistaken in syntax of sql

image
image1366×768 67.7 KB

can anyone tell me the right syntax

2

Looks like you have a problem with your SQL string query. It would help if you will also post your code here.

3

select tabEmployee.first_name,tabEmployee.employee from tabEmployee
where tabEmployee.date_of_birth = ‘01-01-1990’;

image
image1366×768 70.6 KB

4

Hi, @silocoegypt, please find below script.

SELECT first_name as 'First Name', date_of_birth as 'Birth Date' FROM `tabEmployee`  WHERE  
date_of_birth = '1960-10-17'

image
image700×404 9.61 KB

image
image948×524 11.4 KB

1 Like
5

Thank u very much

6

can you tell me the syntax if I will use parameter please