Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-piga-msft's avatar
    v-piga-msft
    8 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
8 years ago

#date(2018, 4, 13) meta [IsParameterQuery=true, Type="Date", IsParameterQueryRequired=true]

hello,
how to pass system date to parameter ....

 


regards

pooja Dhonde