Small and medium business | Business Central, N...

Date data type issue

(0) Share

Report

Posted on by Muhammad Anas Naeemi

386

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?

All responses (7)

Answers (0)

Suggested answer

YUN ZHU 77,925 Super User 2025 Season 1 on at

Like (0)

Report

Date data type issue

Hi, sorry for the late reply, I hope the following information can give you some help.

Dynamics 365 Business Central: Select the only Year (Month or Day) when entering dates（Only year drop）

https://yzhums.com/38029/

Thanks

ZHU
Suggested answer

Nitin Verma 21,273 Moderator on at

Like (0)

Report

RE: Date data type issue

You can try with MinValue, MaxValue, ValuesAllowed property of that field.
Muhammad Anas Naeemi 386 on at

Like (0)

Report

RE: Date data type issue

One thing more I want to ask. How can we limit number of digits in an integer datatype field.
Muhammad Anas Naeemi 386 on at

Like (1)

Report

RE: Date data type issue

Okay Nitin. Thank you.
Suggested answer

Nitin Verma 21,273 Moderator on at

Like (0)

Report
RE: Date data type issue

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; }
Muhammad Anas Naeemi 386 on at

Like (0)

Report

RE: Date data type issue

Hey Nitin, thank you for responding but it is not working.
Suggested answer

Nitin Verma 21,273 Moderator on at

Like (0)

Report
RE: Date data type issue

Hi,

Can you try this? If it helps you

field(DateField; FORMAT(rec."New Date Field", 0, '')) { ApplicationArea = all; }