SELECT c.ContactName AS [Contact Name],
c.firstname as [First Name],
c.surname as [Surname],
T.OrganisationV6 AS [Company],
c.position as [Position],
c.Email AS [E-mail],
LTRIM( ISNULL(c.Phone1CountryCode,'') +
ISNULL(' ' + RTRIM(c.Phone1AreaCode),'') +
ISNULL(' ' + RTRIM(c.Phone1),'') ) as [Contact Phone 1],
LTRIM( ISNULL(c.CellCountryCode,'') +
ISNULL(' ' + RTRIM(c.CellAreaCode),'') +
ISNULL(' ' + RTRIM(c.Cell),'') ) as [Contact Mobile],
CONVERT(varchar(12),c.CreateDate,106) as [Contact Creation Date]
FROM tblContact c
LEFT OUTER JOIN tblLinkCustContact L ON C.ID = L.ContactID
LEFT OUTER JOIN tblCust T ON L.Customer_code = T.Customer_code
WHERE CONVERT(varchar(12),c.CreateDate, 112) >= CONVERT(varchar(12),GETDATE()-31, 112)