Creating Custom Variable

[Syndicate_Admin]

I am new to Power Query and am using Power Apps to build a blank query connection to an API source. I am needing the startTime always to be constant, which is simple, but the endTime needs to be the current date in a specific format. See below and please advise:

let

startTime = "2022-09-26T19%3A08%3A25Z",

endTime1 = Date.From(DateTime.LocalNow()),

endTime2 = Date.Year(Date.From(DateTime.LocalNow())),

endTime3 = Date.Month(Date.From(DateTime.LocalNow())),

endTime4 = Date.Day(Date.From(DateTime.LocalNow())),

endTime = "endTime2"&"-"&"endTime3"&"-"&"endTime4"&"T19%3A08%3A25Z"

Hoping to end (if using today) as "2022-10-04T19%3A08%3A25Z"

[Syndicate_Admin]

Perfect! Thank you.

[BA_Pete · Accepted solution]

Hi @Syndicate_Admin ,

Try this:

Text.Combine(
    {
        Date.ToText(DateTime.Date(DateTime.LocalNow()), "yyyy-MM-dd"),
        "T19%3A08%3A25Z"
    }
)

As a query:

let
    Source =
    Text.Combine(
        {
            Date.ToText(DateTime.Date(DateTime.LocalNow()), "yyyy-MM-dd"),
            "T19%3A08%3A25Z"
        }
    )
in
    Source

Output:

Pete