Announcements
Hi,
I have this column in excel:
I want to show the date in my apps. But, it going to be wrong date.
Does anyone know how to fix it? Thankyou.
Hi @firda59 ,
The correct result shown in my test means that your statement should be fine, and perhaps you can check which data ThisItem.Target refers to.
I suggest you create a separate Label control to display it to check if it is the value you need.
Best regards,
Rimmon Li
@v-mengmli-msft
I dont understand, it still error, the date still different😔
If you have such data in your data source:01-Jul-77, it is possible that ThisItem indicates the table where the data is located instead of the table where the Target column you want to be located. So you can check the Item property of the Form to check if it is the table where the Target column is located.
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 404
timl 344 Super User 2026 Season 1
WarrenBelz 320 Most Valuable Professional
