Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

SQL Statement Dynamic Date range

Hi all,   I need to make the EndDate and StartDate respectively, in the following line a dynamic date range.   Sql.Database("Server", "DB", [Query= "exec dbo.WhatEver 'yyyy-mm-dd', 'yyyy-mm-dd'"]...
Need Help
  • kaldorr's avatar
    kaldorr
    New Member
    3 years ago

    Hello Daryl,

     

    I actually solved it by doing to following,

     

    Start = Date.ToText(DateStart, "yyyy-MM-dd"),
    End = Date.ToText(DateEnd, "yyyy-MM-dd"),
    Query = "execute statement" & " " & "'" & End & "'" & ", " & "'" & Start & "'",

    Source = Sql.Database("Server name", "Database", [Query= Query])

     

    Where the DateEnd and DateStart were determined as follows

     

    Date.AddDays(Date.EndOfWeek(Date.From(DateTime.LocalNow())), -8)

    Date.AddDays(Date.EndOfWeek(Date.From(DateTime.LocalNow())), -15)

     

    Respectively