I have a Listbox, the RowSource is:
Code:
lstView.RowSource = "select ID,Chop_Date, GWIS_ID,Card_Number,Customer_Name,Complaint_Category,Status from tbl_PaperTeam"
i need to format the date. so i modified the row source as
Code:
lstView.RowSource = "select ID,format([Chop_Date],"dd-mmm-yy"), GWIS_ID,Card_Number,Customer_Name,Complaint_Category,Status from tbl_PaperTeam"
But after writing the code and going to next line i got the following error
"Compile Error.Expected: end of statement"
and the cursor is pointing on "dd-"
How ever that query got executed when i checked in Query Window.
Please assist me to get my expected format date