Datetimezone conversion

[alitzellachner]

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

[alitzellachner]

Thank you- worked

[rubayatyasmin]

Happy to help. 

[rubayatyasmin · Accepted solution]

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.