Al Zahia Inbound Campaign

select * from zahia_communitymanagement where CONVERT(VARCHAR(12), cast(DATE_OF_CALL as DATE), 101)=CONVERT(VARCHAR(12), GETDATE(), 101) order by DATE_OF_CALL

Al Zahia

Survey Report(mm/dd/yyyy)
From	To

Total Report

Sr No.

UNIT_NUMBER

PHASE_NAME

TYPE_OF_APPARTMENT

CUSTOMER_NAME

MOBILE

EMAIL_ADDRESS

REASON

TYPE_OF_CALL

DATE_OF_CALL

CALLSTATUS