Forum Discussion
pass system date advance editor
let
Source = Sql.Database("localhost", "Vendor03_04", [Query="select * from [EOLShiftData] where startts = dbo.GetShiftDate('" & DATE & "','s',1) and endts = dbo.GetShiftDate('" & DATE & "','e',1)", CreateNavigationProperties=false]),
#"Added Conditional Column" = Table.AddColumn(Source, "Shift", each if [Tag] = [Tag] then 4 else 4),
#"Split Column by Delimiter" = Table.SplitColumn(#"Added Conditional Column", "Tag", Splitter.SplitTextByEachDelimiter({"'"}, QuoteStyle.Csv, false), {"Tag.1", "Tag.2"}),
#"Changed Type" = Table.TransformColumnTypes(#"Split Column by Delimiter",{{"Tag.1", type text}, {"Tag.2", type text}}),
#"Split Column by Delimiter1" = Table.SplitColumn(#"Changed Type", "Tag.2", Splitter.SplitTextByEachDelimiter({"'"}, QuoteStyle.Csv, true), {"Tag.2.1", "Tag.2.2"}),
#"Changed Type1" = Table.TransformColumnTypes(#"Split Column by Delimiter1",{{"Tag.2.1", type text}, {"Tag.2.2", type text}}),
#"Removed Columns" = Table.RemoveColumns(#"Changed Type1",{"Tag.1", "Tag.2.2"}),
#"Renamed Columns" = Table.RenameColumns(#"Removed Columns",{{"Tag.2.1", "Tag"}})
in
#"Renamed Columns"
hello ,
In this sql query '"DATE"' created parameter but i want to pass syatem date as a defalt function which can refresh my data as current date data available in database
how can i ??
Anonymous,
You may refer to the code below.
& Date.ToText(if DATE is null then DateTime.Date(DateTime.LocalNow()) else DATE) &
1 Reply
- v-chuncz-msftCommunity Support
Anonymous,
You may refer to the code below.
& Date.ToText(if DATE is null then DateTime.Date(DateTime.LocalNow()) else DATE) &