Forum Discussion

andyor's avatar
andyor
Resolver I
3 years ago

Testing date output validity

How can I test all the various Power BI date outputs to check if I'm using them valid/correct?   E.g. In SQL Server I can do SELECT getdate() and that will output the current date/time in the conso...
Need Help
andyor's avatar
andyor
Resolver I
3 years ago

Thanks but I'm looking to find out how to pass those as Paramters. I can creat the paramaters but how can I insert them into the query through advanced editor?

 

let
    Source = Sql.Database("DataBase1", "XXX", 
    [Query="DECLARE#(tab)@return_value int#(lf)#(lf)EXEC#(tab)
    @return_value = [Reporting].[Report1]#(lf)#(tab)#(tab)
    @TimeZoneID = 1,#(lf)#(tab)#(tab)
    @TZStartDate = N'2022-09-01',#(lf)#(tab)#(tab) ---want to enter my start date parameter here 
    @TZEndDate =  N'2022-09-12',#(lf)#(tab)#(tab)  -- want to enter my end date parameter here
    @DateType = 3#(lf)#(lf)SELECT#(tab)
    'Return Value' = @return_value"])
in
    Source
MahyarTF's avatar
MahyarTF
Memorable Member
3 years ago

Are you using the below code in PQ :

DateTime.LocalNow()

It is shown the current Date-Time

  • andyor's avatar
    andyor
    Resolver I
    3 years ago

    But how would you know? There's no output console in PQ that I can see. I think you're not understanding 1 part of the question