Date String to Date format "dd/mm/yyyy" when different user's settings for read date are used.

[joao123]

Hello,

I have a huge problem that I cannot figure out a solution, that is why I'm asking for your help.

I created a data base in sharepoint, where some dates are strings instead of datetype (it has to be this way). The problem is when users with different date setting are using the APP, some with the default setting of "dd/mm/yyyy", see the date in the datepickers alright, because it is the format saved in sharepoint, in other hand, the users with the default settings of "mm/dd/yyyy" see the date all wrong.

I don't know how to fix this, but I think I have a few options, but in all of them I have some questions:

Option 1 - Asking every user to change the defaults setting to format "dd/mm/yyyy" 

Definitions and privacy:

I tried change here, but the problem still persists. Probably the settings should be change somewhere else, but I don't know where.

2 Option - Having some way to tell powerapps that the date string is in the "dd/mm/yyyy" format, forcing the powerapps to read that way.

Maybe there is another option, please feel free to add some more.
I really need your help.

Thank you in advance.

[v-bofeng-msft · Accepted solution]

Hi @joao123 :

Please try:

DateValue("08/09/2021","da-DK")

I think this link will help you a lot:

DateValue

Best Regards,

Bof

[joao123]

Thank you @v-bofeng-msft  it works now. I was doing this all wrong.