Share
Report
84Hi,
My app calls several procedures in SQL server and passes datetime parameters. I store these parameters in a datetime variable in PowerApps. Since my app is used by internationally, it can generate the two datetime formats below based on the users local settings. The issue is when SQL server receives the datetime variable, it tries to process it in US format since the SQL server resides in the US. Thus, if it receives 20/1/2023 8:00 it throws an error because that isn't aa valid date. I need to find a way to send my datetimes in a uniform format, preferably US format, so SQL can interpret them correctly. I want to continue to allow the user to view the dates and times in his own format as PowerApps does by default. I just want to alter it when I store it in the variable.
US- 1/20/2023 8:00
Europe- 20/1/2023 8:00
All responses (
Answers (
