No reason to assume that you’ll have to do everything yourself. The system library is getting more and more useful functions, check this out:
Tag Archives: DATETIME
Handy Date-Time Dialog in Business Central
Did you ever need a DateTime field in your Business Central extension?
I recently added, in one of my customer extensions, a DateTime field, and wanted to allow users to not only record a date, but also a time.
Dynamics 365 Business Central: Date-Time Dialog
Today I would like to talk about the best practice for entering DataTime values in Dynamics 365 Business Central.
First, let’s look at what the DateTime Data Type is.
Tip: Evaluating DateTime with Type Helper
Dates. What a nightmare. Day/Month/Year? Month/Day/Year? 24 hour time? 12 hour time? It’s almost enough to make you sympathetic to the idea of decimal time…almost.
Unix Datetime UTC
Here’s a little trick to generate a Unix Datetime in UTC.
Power BI Model Size Bloat And Auto Date/Time Tables
Opinion is split over Power BI’s ability to automatically create Date hierarchies in your model. Personally it drives me mad and I always turn it off, but I know a lot of people love the convenience of it. Whatever your feelings, though, it is important to be aware of the problems it can cause with the size of your model.
Handle DateTime – Use DotNet Variable
Calculating exact Day, Time, No of Month in a Day, Number of days in a Year, Day of the Week and many more has always been a challenging point while writing code in NAV. Though you can manage to achieve this but anyhow you end up with many lines of code. But just twisting your code a little bit with some DotNet variable will bring you a broad smile in your face with just a single line of codes. For an example have a look into the below screenshot.