Re: Date format multi timezone year changing
@robinisathakur ,\
I was suspecting you were going to tell me that. Unfortunately, the rest of the world (outside the USA) format dates in a logical ascending (day-month-year) fashion, but that is another discussion.
My first suggestion is to make it a date/time field and all will work as expected.
Beyond that, you could turn it back "the right way" ( I am assuming your Country format is USA - it is Australia here)
If(
Office365Users.MyProfile().Country = "USA",
DateValue(ThisItem.YourFieldName),
With(
{
_Data: Split(
ThisItem.YourFieldName,
"/"
)
},
Date(
Last(_Data).Value,
First(_Data).Value,
Index(
_Data,
2
).Value
)
)
)
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
MVP (Business Applications) Visit my blog Practical Power Apps
