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

cs566

New member
Joined
Jun 12, 2015
Messages
2
Reaction score
0
Points
0
Excel Version(s)
2016
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/
 
Code:
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each DateTime.LocalNow() as datetime),
    #"Changed Type1" = Table.TransformColumnTypes(#"Added Custom",{{"Custom", type date}})
 
Code:
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each DateTime.ToText(DateTime.LocalNow(), "dd/MM/yyyy"))
 
Last edited:
Back
Top