Patch Text input to Date field on Edit form

[TorreyFalconer]

Hello hello

So I would like to use a text input box in Powerapps to update a date column in Sharepoint. I realize this sounds silly, but it is just ideal for us. However I cannot seem to get the Patch expression to be able to accomplish this. Any tips? I tried this:

Patch(
'Vehicle Hold Times',
ThisItem,
{'Time IN': 'Textinput_TimeIN'.Text}
)

[PowerAddict]

Hi,

You can use the DateValue function to convert a string to date.

Some more info:
The DateValue function converts a date string (for example, "10/01/2014") to a date/time value.

The TimeValue function converts a time string (for example, "12:15 PM") to a date/time value.

The DateTimeValue functions converts a date and time string (for example, "January 10, 2013 12:13 AM") to a date/time value.

More details can be found here: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-datevalue-timevalue

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution. Thanks!

Hardit Bhatia
https://thepoweraddict.com

[TorreyFalconer]

@PowerAddict  thanks, but how do I use this with the Patch function??

[PowerAddict · Accepted solution]

Try something like this:

Patch(
'Vehicle Hold Times',
ThisItem,
{'Time IN': DateValue('Textinput_TimeIN'.Text)}
)

Let me know if this helps.

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution. Thanks!

Hardit Bhatia
https://thepoweraddict.com

[PowerAddict]

Glad I could help! Good luck with the rest of your app! Feel free to reach out in case of any questions!

Thanks,
Hardit Bhatia
The Power Addict
https://thepoweraddict.com

[RatanKP]

Am facing a serious problem with DateValue('Textinput_TimeIN'.Text), as per my SQL Table the Data is in "YYYY-MM-DD" format and when I fetch the data from SQL to Powerapps am receiving the Values as "MM/DD/YYYY"(may be due to SQL Server Sytem Date configuration) and I used Text function to convert to "YYYY/MM/DD" and when am passing the value to date field I got text Conversion error and I used DateValue to convert Text to Date Format and  system is converting the DateFormat automatically to "MM/DD/YYYY", I want to convert the Text to DateFormat in "YYYY/MM/DD" Format, any Suggestions would be appreciated.

Thank you in advance for all.