Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
hello,
how to pass system date to parameter ....
#date(2018, 4, 13) meta [IsParameterQuery=true, Type="Date", IsParameterQueryRequired=true]
regards
pooja Dhonde
Solved! Go to Solution.
Hi @Anonymous,
You could create a Blank Query by DateTime.LocalNow() in Query Editor to get the system time.
Then you try to use this accessing data funtion below in the Advanced options when you get data from SQL Server Datebase.
Sql.Database(server as text, database as text, [Query = "select A from table where..." & "localtime"]) as table
In Addition, you could have a good reference of DateTime.LocalNow() and Sql.Database.
Best Regards,
Cherry
Is that a statement or a question?
DateTime.LocalNow will give you the "system time"
Hi @Anonymous,
You could create a Blank Query by DateTime.LocalNow() in Query Editor to get the system time.
Then you try to use this accessing data funtion below in the Advanced options when you get data from SQL Server Datebase.
Sql.Database(server as text, database as text, [Query = "select A from table where..." & "localtime"]) as table
In Addition, you could have a good reference of DateTime.LocalNow() and Sql.Database.
Best Regards,
Cherry
Thank you..
Hi @Anonymous,
That' my pleasure.
Best Regards,
Cherry
#date(2018, 4, 13) meta [IsParameterQuery=true, Type="Date", IsParameterQueryRequired=true]
hello,
how to pass system date to parameter ....
regards
pooja Dhonde
User | Count |
---|---|
97 | |
88 | |
76 | |
70 | |
63 |
User | Count |
---|---|
112 | |
96 | |
95 | |
67 | |
65 |