Announcements
sorry my english ... i have a need. I have the date in a table sql in 20200116 format in char (8) format. I need to display it in the app mask, in the 16/01/2020 format. Could you recommend me? I attach the mask Thanks in advance!
thanks for the reply, but if I have this function, where should I insert it to extract the data in the correct format?
SortByColumns(Filter('[dbo].[USR_APPUNTAMENTI]';Value(DATAAPP)>=Value(Label38.Text) And Value(DATAAPP)<=(Value(Label5_1.Text))And CODICENEGOZIO=Dropdown2.Selected.CODMAGAZ And TIPOVISITA=Dropdown4.Selected.DESCRIZIONE);"DATAAPP")
I solved it like this:
Text(DateValue(DATAAPP); "[$-it-IT]dd/mm/yyyy")
Thank's
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 220 Super User 2026 Season 2
WarrenBelz 189 Most Valuable Professional
Mohsin Ali 139