Finance | Project Operations, Human Resources, ...

How to hide future dates in the date dropdown

(1) Share

Report

Posted on by Adam123

522

Hi Guys,

In the date dropdown field we have all the dates like past and future dates, but I need to disable the future dates in d365fo. can you please help me to solve this.

All responses (6)

Answers (0)

Suggested answer

Adis 2,428 on at

Like (0)

Report

How to hide future dates in the date dropdown

Hey,

I would suggest the following.

Take any form go to Options\Regord info\Database log (see 1) - it doesnt matter if you have the database log active on this table.

In the created date and time column the to date (see 2) is the current date. Check in visual studio how that was implemented and reuse the code.

For the "From date" you could just delete the entry, which will imply being 01/01/1900

Kind regards, Adis
Komi Siabi 12,711 Most Valuable Professional on at

Like (0)

Report

How to hide future dates in the date dropdown

The date drop-down showing all dates is a system design and you won't be able to change it. However, you should be able to control it individually on tables.

By the way, like Amine said, you can validate the date.
Raj Borad 494 on at

Like (0)

Report

How to hide future dates in the date dropdown

Hi,

What is the reason for such requirement?
Suggested answer

Anton Venter 18,788 Super User 2024 Season 2 on at

Like (1)

Report

How to hide future dates in the date dropdown

Hello,

You could create a custom lookup form and filter out future dates.
Suggested answer

Mohamed Amine Mahmoudi 9,738 Super User 2024 Season 2 on at

Like (0)

Report
How to hide future dates in the date dropdown

Hi @Adam123,

it's better to use validation to prevent the user to select a future dates.

for e.g. you can use the validateWrite in your table or datasoure in form :

public boolean validateWrite() { boolean ret; ret = super(); if(this.yourDateField > SystemDateGet()) { ret = checkFailed("your message here"); } return ret; }

Best regards,

Mohamed Amine MAHMOUDI
Mohamed Amine Mahmoudi 9,738 Super User 2024 Season 2 on at

Like (0)

Report

How to hide future dates in the date dropdown

Moved from MS Dynamics AX Form