Announcements
Hi Team.
I am working on an application and my database is a Sharepoint list and I have a column calculated to add 8 months to a date & time column, but when I show it in PowerApps I see it in a different way and I tried with the Text function but I can't change the display of the value, can you help me?
@jaimeMtz07
Try Text(ThisItem.Venice,"dd-mm-yyyy")
or
DateValue(ThisItem.Venice,"en-US")
Since the column looks to be displaying as a date field in SharePoint, it's likely just to be a display issue on the Canvas app.
Try this formula in the gallery label:
Text(ThisItem.VENICE,ShortDate)
Note you may have issues with timezones, but if the date is 8 months out it mightn't be a big deal.
Not working 😞
Hello @jaimeMtz07 ,
Using the DateTimeValue function seems to do the trick for me, so in your case:
DateTimeValue(ThisItem.VENCE)
If you want to add more formatting, you could use:
Text(DateTimeValue(ThisItem.VENCE), DateTimeFormat.LongDateTime)
Hope it helps!
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 community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 395 Super User 2026 Season 2
Mohsin Ali 328
WarrenBelz 260 Most Valuable Professional
