Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Automatically updating datess in SQL code

Hello,   We're importing tables from a SQL server and are running some SQL before it's imported from the "SQL Server Database" window and using the "Advanced Options">"SQL Statement" box into Power...
Need Help
  • RobbeVL's avatar
    RobbeVL
    7 years ago

    Have a Look at GETDATE() in SQL.

    Will give you the current DateTime

RobbeVL's avatar
RobbeVL
Impactful Individual
7 years ago

Hi,

 

You could use Parameters in PowerQuery.

But still a manual interaction will be needed.

 

Why dont you use Relative date functions in your SQL Query instead?

 

Robbe

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Thanks for your quick reply.

     

    Sorry stupid question: How would I do that?

     

    Thanks

     

    Stuart

    • RobbeVL's avatar
      RobbeVL
      Impactful Individual
      7 years ago

      Have a Look at GETDATE() in SQL.

      Will give you the current DateTime

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Ah right, For some season I thought these functions wouldn't work in Power BI.

         

        Thanks