pass system date advance editor

[Anonymous]

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 ??

[v-chuncz-msft · Accepted solution]

@Anonymous,

You may refer to the code below.

& Date.ToText(if DATE is null then DateTime.Date(DateTime.LocalNow()) else DATE) &