Forum Discussion

alitzellachner's avatar
alitzellachner
Frequent Visitor
3 years ago
Solved

Datetimezone conversion

Hy,

I'm new in Power BI and in this forum but currently didn't find an appropriate solution 🙂
I want to get the actual date and time (UTC) into a ISO 8601 standard text with format yyyy-mm-ddThh:mm:ss:Z.

I need this for a dynamic API url request. I tried with DateTimeZone.utcnow() and the time.totext function but don't get it. 

 

Thanks for help,

best regards,

Andreas

Need Help
  • rubayatyasmin's avatar
    rubayatyasmin
    3 years ago

    Hi, alitzellachner 

     

    try using this way. 

     

    let
    CurrentDateTime = DateTimeZone.UtcNow(),
    ISOFormat = DateTimeZone.ToText(CurrentDateTime, "yyyy-MM-ddTHH:mm:ssZ")
    in
    ISOFormat

     

    DateTimeZone.ToText(CurrentDateTime, "yyyy-MM-ddTHH:mm:ssZ") formats this date and time according to the ISO 8601 format.

     

3 Replies

  • rubayatyasmin's avatar
    rubayatyasmin
    Community Champion
    3 years ago

    Hi, alitzellachner 

     

    try using this way. 

     

    let
    CurrentDateTime = DateTimeZone.UtcNow(),
    ISOFormat = DateTimeZone.ToText(CurrentDateTime, "yyyy-MM-ddTHH:mm:ssZ")
    in
    ISOFormat

     

    DateTimeZone.ToText(CurrentDateTime, "yyyy-MM-ddTHH:mm:ssZ") formats this date and time according to the ISO 8601 format.