Forum Discussion
Pass system date to parameter
hello,
how to pass system date to parameter ....
#date(2018, 4, 13) meta [IsParameterQuery=true, Type="Date", IsParameterQueryRequired=true]
regards
pooja Dhonde
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
6 Replies
Is that a statement or a question?
DateTime.LocalNow will give you the "system time"
- Hello,
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
Poojad1Hi 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
