Testing date output validity

[andyor]

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 console. 

2 questions here:

1) How can I do something similar in Power BI Desktop?

2) Is there a nice place that lists all the useful date formats in Power BI e.g., Start of current day, Start of current month etc etc. 

[MahyarTF]

Hi,

Are you looking for the Current Day ?

If yes, you could use the Today() in your code and also you could add the below code for the Current date and First day of the Month :

"TodayDate", TODAY(),

"Start of Current Month",date(YEAR(TODAY()),Month(EOMONTH(TODAY(),0)),"01")

Appreciate your Kudos

[andyor]

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]

Are you using the below code in PQ :

DateTime.LocalNow()

It is shown the current Date-Time

[andyor]

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