But how does it work? In this article, we’ll take a closer look at the M code behind the Date.From function and explain exactly how it converts text strings into dates.

Understanding the Date.From Function

Before we dive into the code behind the Date.From function, it’s important to understand how it works. Essentially, the function takes a text string in a specific format and converts it into a date format that can be used in your data analysis.

The text string can be in a variety of formats, including “yyyy-mm-dd”, “mm/dd/yyyy”, “dd-mm-yyyy”, and more. The function then uses this format to extract the year, month, and day values from the text string and combine them into a date format that can be used in your analysis.

The M Code Behind the Date.From Function

Now that we understand the basic functionality of the Date.From function, let’s take a closer look at the M code behind it.

The Date.From function is actually a simple wrapper for the Date.FromText function. The Date.FromText function is responsible for taking the text string and converting it into a date format that can be used in your analysis.

Here’s an example of the M code that powers the Date.From function:

let

Source = #”SomeData”,

#”Converted to Date” = Table.TransformColumns(Source, {{“DateColumn”, each Date.FromText(_, “yyyy-mm-dd”), type date}})

in

#”Converted to Date”