I was answering a question for a student in one of my online training courses this week. The question was, “Do you know of a way in power query to efficiently extract YYYY-MM from a Date column?” This can be done ‘manually’ with multiple steps including:
There are various places throughout Microsoft Dynamics 365 Business Central where you can enter dates in fields. In fact, a good deal of data in the application is linked to dates. For example, in a sales order, you can set the shipment date. When filtering lists or report data, you can enter dates and times to pinpoint only the data you want to see. If you look at a sales order, an invoice. or a credit memo, there are document dates, posting dates, and date of entry.
This blog post is about something powerful but hidden within Microsoft Dynamics NAV. I believe many developers always work with dates over and over during their day-today life and i’m sure many of you have done many functions which convert, split and do all sort of things with date.
Date fields on Microsoft Dynamics NAV sales and purchase orders can be confusing but very beneficial if used correctly. The dates are designed to allow you to:
•Schedule shipment in time to meet the customer’s requested delivery date.
•Schedule the receipt of product in time to ship the order on the desired date.
•Track your vendor’s delivery performance.
Date Fields on Microsoft Dynamics NAV sales and purchase orders can be confusing, but very beneficial if used correctly. The dates are designed to allow you to:
•Schedule a shipment in time to meet the customer’s requested delivery date.
•Schedule the delivery of a product in time to ship the order on the desired date.
•Track your delivery performance to your customer.