#datetime Function in Power Query

The #datetime function in Power Query creates a datetime value from year, month, day, hour, minute, and second.

Syntax

#datetime(
  year as number, 
  month as number, 
  day as number, 
  hour as number, 
  minute as number, 
  second as number
) as datetime     

Example: Let’s create the datetime value.

Power Query M

let
    Source = #datetime(2025,2,24,20,45,52)
in
    Source        

The output of the above code is 24-02-2025 20:45:52.