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

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?


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.

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.

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