Dear,
I have created an SQL view and added a smartlist..
the following is the view:
SELECT CONVERT(VARCHAR(10), C.CREATDDT, 103) AS [CREATION DATE], P.PRCSHID AS [PRICE SHEET], P.LINKCODE AS [CUSTOMER ID],
C.CUSTNAME AS [CUSTOMER NAME], C.STMTNAME AS [CUSTOMER ARABIC DESC], C.SLPRSNID AS SALESPERSON, C.CUSTDISC / 100 AS [TRADE DISCOUNT],
C.USERDEF1 AS [ROUTING DAY],
CASE D .DSCTYPE WHEN 1 THEN 'INV Range %' WHEN 2 THEN 'INV Monthly %' WHEN 3 THEN 'INV Fixed' WHEN 4 THEN 'RCP Monthly %' END AS [Discount Type]
FROM dbo.RM00500 AS P INNER JOIN
dbo.RM00101 AS C ON P.LINKCODE = C.CUSTNMBR INNER JOIN
dbo.DSC00101 AS D ON C.CUSTNMBR = D.CUSTNMBR
As you can see, i have converted the "created date" to a date format (it's highlighted)..
in the smartlist, i have also added a calculated field that converts the "Created Date" as follows:
CONVERT(VARCHAR(10), {*NEWLY_CREATED_CUSTOMERS:CREATION DATE} , 103)
But, as a result, the smartlist is not showing any data, only the column "creation date" is showing "00/00/0000".
So please could someone help me or show me what may be missing?
Thank you in advance,
Mona
