Code:#"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each DateTime.LocalNow() as datetime), #"Changed Type1" = Table.TransformColumnTypes(#"Added Custom",{{"Custom", type date}})
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 by Bob Phillips; 2019-11-01 at 03:34 PM.
Bookmarks