Announcements
I set format in power app as below.
But data write in file excel = 2021-08-19T17:00:00.000Z
I want to write format date = dd/mm/yyyy
Please guide me about it.
Change the column format in Excel from General to Short Date.
Hi @Anonymous,
If the date getting saved is right than I guess you need to change format of Excel file column into required format.
If you observe one day difference between the date submitted from PowerApps to Datebase than it is due to Timezone difference. Please try the below formula for the Timezone saving if it helps.
DateAdd(datepickercontrolName.SelectedDate,TimezoneOffset(),Minutes)
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
One thing to add to @PriyankaGeethik response. If you are going to use TimezoneOffset() to adjust for the time zone then you really need to pass the date being converted as an argument of the TimezoneOffset. Otherwise it won't allow correctly for daylight savings time. The formula should be.
DateAdd(datepickercontrolName.SelectedDate,TimezoneOffset(datepickercontrolName.SelectedDate),Minutes)
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.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Valantis 483
WarrenBelz 399 Most Valuable Professional
11manish 327
