NAv Quires & adding code to a query which will format the coulmn

Dynamics 365 Business Central/NAV Developers Forum
1

Can I add code to a query? for example I want to create a new column which will return the month from the column date?

is it possible to create some customized Columns?

Thanks

2

regarding the year, month and day you can do them within Quires stander Function. But I guess you canot add code to your query that will manipulate data within your query.

3

What kind of code/formatting did you want to put to the queries? I think you’ll have to do the formatting when displaying the data in a report or page.

4

Can recommend this article about queries (from David Studebaker and son’s book):

http://msdynamicsworld.com/story/high-performance-data-access-why-and-how-use-queries-microsoft-dynamics-nav-2015