Forum Discussion
Pass system date to parameter
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
That is question not statement ..
Can you explain more how to pass DateTime.LocalNow in advance editor for above query.
Actually my database is SQL and I want to pass system date that time that will fetch data from database and will show on dashboard. I have created parameter but can I pass system date to that parameter???and how??
Regards
Poojad1
Resident RockstarHi 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..
- v-piga-msft
Hi Anonymous,
That' my pleasure.:smileywink:
Best Regards,
Cherry