cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

Convert date format to ISO without changing timezone?

Is there a way to change datetime value to ISO format (to use later in calendars) without having to change to UTC timezone? 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Convert date format to ISO without changing timezone?

Hi @BrittanyR ,

Could you

1)describe  more clearly about the date format that you want?

2)tell me  what formula do you use to represent datetime value?

Usually, the date iso format is like this:
YYYY-MM-DD

For example: "3rd of April 2002", in this international format is written: 2002-04-03.

I assume that you use "ThisItem.timefield" to represent the datetime value that you want, and this field is datetime data type.

 

If so, you just need to use Text function to transfer time to the format that you want.

Try this formula:

Text(ThisItem.timefield,"[$-en-US]yyyy-mm-dd")

 //time format: "yyyy-mm-dd"

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Highlighted
Impactful Individual
Impactful Individual

Re: Convert date format to ISO without changing timezone?

Text(Now(), "[$-en-US]yyyy-mm-ddThh:mm:ss,")&"000000000"&"<-0800>"

 

<your timezone offset>

 

Highlighted
Community Support
Community Support

Re: Convert date format to ISO without changing timezone?

Hi @BrittanyR ,

Could you

1)describe  more clearly about the date format that you want?

2)tell me  what formula do you use to represent datetime value?

Usually, the date iso format is like this:
YYYY-MM-DD

For example: "3rd of April 2002", in this international format is written: 2002-04-03.

I assume that you use "ThisItem.timefield" to represent the datetime value that you want, and this field is datetime data type.

 

If so, you just need to use Text function to transfer time to the format that you want.

Try this formula:

Text(ThisItem.timefield,"[$-en-US]yyyy-mm-dd")

 //time format: "yyyy-mm-dd"

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
secondImage

New Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (8,104)