Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago
Solved

Creating Custom Variable

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"

  • BA_Pete's avatar
    BA_Pete
    3 years ago

    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

2 Replies

  • BA_Pete's avatar
    BA_Pete
    Super User
    3 years ago

    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