Announcements
HI, I'm building my first app with data connected to an excel spreadsheet. It's for tracking employee training, the first screen is for staff details. there's a column in the spreadsheet for 'Date_Started' that is formatted as a short date dd/mm/yyyy. When I try to add that field to my Form, it displays a 5 digital number e.g. 44833. How can I get this to display as a date as per the data in the spreadsheet column?
Hi @BillFarq ,
You would need
DateAdd( Date(1900,1,1), YourNumber -1, TimeUnit.Days )
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.
MVP (Business Applications) Visit my blog Practical Power Apps
Thanks @WarrenBelz , but I'm unclear where I should be adding that. In addition, when I try to add a field to my form for MoodleUser (Yes/No), it provides a date picker, so the app doesn't seem to recognize the format of the data in my connected spreadsheet. Can you have a look at the screenshot attached?
Hey @BillFarq ,In the default property of your DataCardValue2, you need to format the input to get the actual date value. Example: Text(ThisItem.ActualStartDate, "dd-mm-yyyy").
Please click Accept as solution if my post helped you solve your issue.
Excel and dates are not the best friends - if that is a number and you are using a Date Picker, you can try this as the DefaultDate
DateAdd( Date(1900,1,1), ThisItem.ActualStartDate -1, TimeUnit.Days )
Thanks @WarrenBelz , that helped, instead of adding the field form from the available list in 'Add field' I added a custom control, date picker and used the script above, that has worked nicely, thanks!
@BillFarq ,
What "script above" did you use ?
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 381 Super User 2026 Season 2
Mohsin Ali 340
WarrenBelz 187 Most Valuable Professional
