How to convert date time to date in Microsoft Dynamics Navision.



We use FORMAT function for convert any date format

Ex. FORMAT("Bank Account Ledger Entry”. “Posting Date",0,' <Day,2>.<Month,2>.<Year4>')

OUTPUT: 18.08.2016

Comments

Post a Comment

Popular posts from this blog

How to make and use web service in Microsoft Dynamics Navision.

Image
Web services is use to do operation on data of NAV from outside the NAV environment, you can’t insert, update, delete the data of NAV using web service with proper authentication. For creating the web service in NAV follow below steps. (Here we are making the web service with gives vendor name based on vendor number. And we consume this service in windows application outside the NAV area.) Open NAV development environment and create the new code unit. Make one function “GetVendorName” Function name: GetVendorName Input Parameter : VendorNumber Output (Return) parameter : VendorName Now write below code in function. IF Vendor.GET(VendorNo)THEN BEGIN     EXIT(Vendor.Name); END ELSE BEGIN     EXIT('Vendor Not Found'); END Now save this codeunit with proper Id and Name. Now open the client application module and search for ‘Web service’ in search text box.  Open the “Web service page” and click on “NEW” button, it will ask following details Object Type: Codeunit Obj...
Read more

How to use Format function in Microsoft Dynamics Navision.

Image
Format function is use to display date in various format some example given below. Format function take 3 input argument First: date which you want o display Second: number of character return by default is 0 (o means return all the string) Third: string format in witch you want to convert. Example: 1 MESSAGE('Today  date is : %1 ', FORMAT(TODAY,0,'<Month Text> <Day,2> <Year4>')); OURPUT: Emaple:2 MESSAGE('Today  date is : %1 ', FORMAT(TODAY,0,' <Day,2> <Month,2> <Year4>')); OUTPUT:
Read more

How to create simple report in Microsoft Dynamics Navision.

Image
Report is one type of data representation in NAV , report is use to display data from the database to outside user. Here we make simple customer list report as example, for creating simple report using Microsoft SQL server report builder you have to follow below steps. Open the Microdot Dynamics Navision development Environment and  go to “Tools  >> Options ” and go to “Use Report Builder” variable and set it to “Yes” and  then close screen by clicking on OK. Now go to “Report” table and click on “new” button. It will open new windows, here you have to specify the data item as any table which you want to display in report, and here we take “Customer” table as show in below image Now we have to add column which is used in report so for adding this we have to add data columns  for this, so go to next row and select column as data type and for adding column you can go to Option >> Field  menu option as show in below image. Now select the field which you...
Read more