Thursday, November 2, 2023

SSRS Convert text to Date

 =Format(CDATE(First(Fields!DueDate_SalesInvcHeader.Value, "DataSet_Result")),"dd-MMM-yyyy")

Thursday, April 6, 2023

How to access data form Pervasive SQL in SQL Management Studio

Create Linked Server PERVASIVE using OLEDB Provider for ODBC 


 SELECT * FROM OPENQUERY(PERVASIVE,'SELECT * FROM mytable')