Power BI Custom Format String Examples, Part 2: Dates And Times

In my last post I showed lots of examples of how Power BI’s new custom format string feature can be used to format numbers. This post, looking at dates and times, will be a bit different for two reasons: there are a lot more useful examples of custom date and time formats built into Power BI Desktop, and some of the format placeholders listed in the VBA documentation aren’t supported in Power BI.

Source : Chris Webb’s BI Blog
Read more…

How To: Use Purchase Order Dates in Microsoft Dynamics NAV 2017

Date fields on NAV 2017 purchase orders can be confusing, but used correctly, they will improve your purchase order processing. The dates are designed to allow you to schedule the receipt of product in time to meet your shipment commitments and your customer’s delivery expectations.

Source : ArcherPoint
Read more…

How to Use Date Functions in Microsoft Dynamics Business Central On Premises

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.

Bron : ArcherPoint
Lees meer…