cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jayendwil
Regular Visitor

Convert to Australian Time/Date in one expression?

Can these two expressions be put together to form one expression? If so, could you please help 🙂

 

 

formatdatetime(addhours(utcnow(),'10') 'dd-MM-yyyy'

2 ACCEPTED SOLUTIONS

Accepted Solutions
Shujaath_Khan
Super User
Super User

Hi @Jayendwil 

very much you can

 

formatDateTime(addHours(utcNow(),3),'dd-MM-yyyy')

 

 

Shujaath_Khan_0-1657253787379.png

 

And also if you're looking for a specific time you can also try the below expression

formatDateTime(convertFromUtc(utcNow(),'AUS Eastern Standard Time'),'dd-MM-yyyy')
instead of adding hours to UTC

Thanks
Please click Accept as Solution on this reply if it helped to solve your issue, and thumbs-up if you feel this is useful or important in other ways as a boost.

View solution in original post

The expression shall give output in AUS specific time 

and also if you've proper timezone time you don't need to use convert the time instead directly format and user it.

formatDateTime(variables('vardttime'),'dd-MM-yyyy')

 

and for SharePoint check column settings once

know more : https://docs.microsoft.com/en-us/troubleshoot/power-platform/power-automate/converting-time-zone-pow...

 

Thanks

View solution in original post

3 REPLIES 3
Shujaath_Khan
Super User
Super User

Hi @Jayendwil 

very much you can

 

formatDateTime(addHours(utcNow(),3),'dd-MM-yyyy')

 

 

Shujaath_Khan_0-1657253787379.png

 

And also if you're looking for a specific time you can also try the below expression

formatDateTime(convertFromUtc(utcNow(),'AUS Eastern Standard Time'),'dd-MM-yyyy')
instead of adding hours to UTC

Thanks
Please click Accept as Solution on this reply if it helped to solve your issue, and thumbs-up if you feel this is useful or important in other ways as a boost.

Jayendwil
Regular Visitor

Thank you, that has worked!!! @Shujaath_Khan 

 

One more thing - Do you know why my input would show Aus Format, then the output shows Utc Format on my list?

Used this: formatDateTime(convertFromUtc(utcNow(),'AUS Eastern Standard Time'),'dd-MM-yyyy')

Australian Format.png

The expression shall give output in AUS specific time 

and also if you've proper timezone time you don't need to use convert the time instead directly format and user it.

formatDateTime(variables('vardttime'),'dd-MM-yyyy')

 

and for SharePoint check column settings once

know more : https://docs.microsoft.com/en-us/troubleshoot/power-platform/power-automate/converting-time-zone-pow...

 

Thanks

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Users online (1,997)