Hello, I'm facing some issues with consistency in dates format with different users.
The app creates historical records by patching a Dataverse table, recording the date as Text(Now(), "dd/mm/yyyy").
When I retrieve the data, I create a collection in the app and separate the date from the text:
ClearCollect(colHistory,ForAll(Split(LookUp(Notes,Regarding=selectedOrder && Title="History").Description,"<br>"),
{
Result: ThisRecord.Value,
Action:Last(Split(ThisRecord.Value,"-")),
Date: DateValue(Left(ThisRecord.Value, 10)) & " " & TimeValue(Mid(ThisRecord.Value, 10, 7)),
}))
It is working for several users, but one of them has the format set to "November 14, 2023". If this user patches the date it is patched as "14/11/2023" as I set it that way. But when I try to transform the date to the user's format I see "February 11, 2023".
Does anyone know how I can fix this? It is mandatory for each user to see the date as their browser date format.
