Adding a Column with current date (not based on another column)

[cs566]

I am wanting to insert a column in one of my source tables in the transform PQ Editor. The column should reflect the date the query is performed. I don't want the date to reflect the date the report is viewed.
Is there a formula/function that will provide this information.
I have looked at:
Column From Examples
Custom Column
Invoke Custom Function
...but they don't seem to provide what I need.
I am teaching myself PQ and PP and thought this would be an easy thing to do...
Any help would be welcomed and appreciated.
tks/

 

[alansidman]

    #"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each DateTime.LocalNow() as datetime),
    #"Changed Type1" = Table.TransformColumnTypes(#"Added Custom",{{"Custom", type date}})

 

[Bob Phillips]

    #"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each DateTime.ToText(DateTime.LocalNow(), "dd/MM/yyyy"))