How get next working date a computed column in views

(0) Share

Report

Posted on by Prem

Hi All;

I have created a view with WORKCALENDARDATE table. This WorkCalenderTable contains a filed WorkTimecontrol which gives the status of that particular day whether it is working day or not.

My requirement is: - For a non-working day, I need to get the date of next working day in a new computed column against this date.

Below is the sample Data as per my requirement

Trans Date	Worktime control	Next Working Day
16-08-2023	open	16-08-2023
17-08-2023	open	17-08-2023
18-08-2023	open	18-08-2023
19-08-2023	Closed	21-08-2023
20-08-2023	Closed	21-08-2023
21-08-2023	open	21-08-2023
22-08-2023	Holiday	23-08-2023
23-08-2023	open	23-08-2023

Thanks in Advance.

All responses (3)

Answers (1)

Martin Dráb 230,846 Most Valuable Professional on at

Like (0)

Report

How get next working date a computed column in d365fo Views

Yes, I got it, but I don't know what problem you have with it. Please see the suggestion I gave you in the previous reply.

Or are you looking for someone to hire to develop it for you?
Prem 10 on at

Like (0)

Report

How get next working date a computed column in d365fo Views

Hi Martin;

Thanks for your reply.

I need the logic to create NextWorkingDay Computed Column as per the requirement.

Thank you.
Verified answer

Martin Dráb 230,846 Most Valuable Professional on at

Like (0)

Report

How get next working date a computed column in d365fo Views

What exactly do you need from us? Does it mean that you don't know how to create a computed column or you don't know what logic to use there?

I think you just need to find the first record (when sorted by TransDate) with open status and TransDate higher that TransDate of the current record.