How to Use getdate function in Sql Query

Power Query
1

Hi Team,

I have below Query and using Getdate to pull the data.

Select COLUMN1 ,COLUMN2 from Table1 where Modifieddate < getdate …This query i am using in Import option and written above query …

but i am unable to getdata becauase of getdate function…

I can created Custom column n can able create filter i dont want this soluton …i need how to use getdate directly in Query itself…can you please jelp me

2

Hi @amruthdna2018. In T-SQL (assuming this is a SQL Server source), the syntax is getdate().
Greg

3

Hi @amruthdna2018, did the response provided by @Greg help you solve your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark as solution the answer that solved your query. Thanks!

4

Hi @amruthdna2018, we’ve noticed that no response has been received from you since the 18th of March. We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.

5

Hi @amruthdna2018, due to the inactivity, a response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box.

We’ve recently launched the Enterprise DNA Forum User Experience Survey, please feel free to answer it and give your insights on how we can further improve the Support forum. Thanks!