How to find current date -8 working days

Help Studio
, ,
1

Hi,

I need to find the result of current date - 8 working days(excluding the weekends).
i.e., the weekends should not be added while calculating.
Result should be date format.

Can anyone help me with the solution?

2

Hi @rnahasnahasuddin

Try this

Enumerable.Range(1, 20).
    Select(Function(n) DateTime.Now.AddDays(-n)).
    Where(Function(d) d.DayOfWeek <> DayOfWeek.Saturday And d.DayOfWeek <> DayOfWeek.Sunday).
    Take(8).
    Last()

image
image872×402 13.5 KB

Regards,

3

@rnahasnahasuddin

If you want in particular date format then try below

image
image888×392 13.9 KB

Regards,

4

Thanks for the quick response.

Can you please explain what does Enumerable.Range(1, 20), this means?

5

@rnahasnahasuddin

It generates a sequence of the last 20 days (ensuring we have enough days to count back 8 working days).

6
7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.