Enforcing DateTime format

[hoppo123]

Hi,

I have a Patch that writes the following to my excel workbook...

'Requested On':DateTimeValue(Now(),"en"), 
'Due Back By':DateValue(Now()+20,"en")

I'm in the UK so am looking for dd/mm/yyyy format.

When using the app through my browser, it works fine however when I use through the app on my iphone, the dates get mixed up.

The first row below is via my browser. The second row should have the same dates as the first row, but as you can see, they 're different.

As I can't control the settings on the users' phones, is there something I can do to resolve this?

Thanks.

[StalinPonnusamy · Accepted solution]

Hi @hoppo123 

I recommend 2 things

1. Make sure your excel column is date format with (dd/mm/yyyy)
2. Convert to the desired date format in PowerApps like

Text(Now(),"dd/mm/yyyy")

Thanks,
Stalin - Learn To Illuminate

[hoppo123]

Hi, thank you for your reply. I did as you suggest but I get an error, as below. It says Found Type 'Error;  Any ideas why that would be? I've also pasted the excel formatting used.

[StalinPonnusamy]

Hi @hoppo123 

• Convert to DateValue

DateValue(Text(Now(),"dd/mm/yyyy"))

• Another option is to keep the Excel as General text instead of date format and use

Text(Now(),"dd/mm/yyyy")

[hoppo123]

Hi, 

Your original solution worked. i.e. setting the excel column format to General and using... 

Text(Now()+20,"dd/mm/yyyy")

 It didn't appear to work originally as I type TEXT rather than Text in the function name, and the error was not particularly helpful. 

Thanks for your help.