Announcements
Use Date Picker to send to Google sheet, the data is displayed as '2021/08/03, how to set it to display as 2021/08/03?
Please help to answer, thank you
hi@LKAY900,
Text(Replace("’2021/08/03","'",""),yyyy/mm/dd).
Please check the syntax if it appears wrong.
Replacing"'" in the text and formatting to your desired format.
You can use the date value function to send the date value.
In the Update property of the form control, or the applicable Patch() argument, wrap the date in a Text() function:
Text(DatePicker1.SelectedDate,"yyyy/mm/dd")
Hope this helps
Change the format of the date picker to
"yyyy/mm/dd"
Thank you for your reply, the result of using the method you suggested is still the same.
All the provided answers on this are correct. But please check the google sheet column format.
Thank you for your reply, using this method, the result value is not updated in the app, and the google sheet is not returned
Thank you for your reply. The google sheet field has been set to the short date format, but the new data is still the same when returned.
Hi @LKAY900
Can you please open the monitor to see what data is sent to Google sheet (save)?
@StalinPonnusamy
Hi StalinPonnusamy, tested according to your prompts, the process showed success, but the original problem ('2021/08/03) was still not solved.
thank you for your help
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Vish WR 846
Valantis 532
Haque 410
