Announcements
Hey everyone,
There is a small requirement that I have created a table along with some fields. I have one date field in it. I want that whenever I select date from this field there should be only year drop down and not having month and days. How can I do that?
Hi,
Can you try this? If it helps you
field(DateField; FORMAT(rec."New Date Field", 0, '')) { ApplicationArea = all; }
Hey Nitin, thank you for responding but it is not working.
You have to show two fields on the page one field where you will select the Date and in other one it will show the Year of that date. but what you are asking it not possible.
field(DateField; FORMAT(rec."New Date Field", 0, '')) { ApplicationArea = all; } field(DateField2; rec."New Date Field") { ApplicationArea = all; }
Okay Nitin. Thank you.
One thing more I want to ask. How can we limit number of digits in an integer datatype field.
You can try with MinValue, MaxValue, ValuesAllowed property of that field.
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.
OussamaSabbouh 566 Super User 2026 Season 2
YUN ZHU 347 Super User 2026 Season 2
Grigorios Mavrogeorgis 327 Super User 2026 Season 2
