Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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-msft's avatar
    v-chuncz-msft
    Community Support

    Anonymous,

     

    You may refer to the code below.

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