BIRTHDAY ALERT IN SAP BUSINESS ONE

[chandan_kumar17]

Please send the query alert

[Abdul]

Dear,

Whenever you post a question please try to add more details like on which object or module you are facing the issue. If possible try to add screenshots also.

[MD1]

try it

select
T0."ExtEmpNo" as "Employee Code",
t0."lastName",t0."firstName",
t0."FatherName",
t0."jobTitle",
t0."startDate",
t0."birthDate"

from ohem t0
left outer join OHTR t1 on t0."termReason" = T1."reasonID"
WHERE DAYS_BETWEEN (CURRENT_DATE, t0."birthDate") =0

[MD1]

this is hana query

[Former Member]

Showing Error while executing 'Current Date '

Regards'

Brij