Reference a date field in spreadsheet

Hi, staincross 

Method1:

Create a blank query, open Advanced Editor and replace the text there with the code below.  

let
    Source = #datetime(2021, 10, 1, 0, 0, 0)
in
    Source

Rename the query name(date1) and modify the date you want in the advanced editor.

= Table.SelectRows(#"Changed Type", each [Date] > date1)

Method2:

Select the date of the cell you want, load the date into Power Query, and check with or without table header.
Then modify the loaded query, add the following code at the end of the query, and rename the query name.

{0}[Rdatetime]
// or
{0}[Column1]

Result:

Please refer to the attachment below for details.

Hope this helps.

Best Regards,
Community Support Team _ Zeon Zheng

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.