How to convert axapta date to sql datetime in query str sqlstr; sqlstr = "SELECT * FROM LedgerJournalTrans WHERE DATAAREAID=ā " + curExt() + "ā " + " AND CreatedDate<CAST(ā " + date2str(str2date(ā22/02/2006ā²,123),321,2,3,2,3,4) + " ā AS datetime) " + " AND CreatedDate> CAST(ā " + date2str(str2dateā20/02/2006ā²,123),321,2,3,2,3,4) + " ā AS datetime) "; CurExt() is a method to get current company. you can sql query in axapta and you can convert date to datetime in query as mention above/
Microsoft Dynamics Ax,AIF,Axapta, Enterprise portal,,Microsoft , United State,U.S., SharePoint , BI Tools, Performance Tuning, SSRS,Business Logic,Ax ERP Errors and solution,Dynamics 365 Errors Solution,Business software .