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

Permanent date filter for orders today + 1 week day

(0) Share

Report

Posted on by gmoreau

Hi,

I want to create a permanent filter in my orders to see al the orders due today + 1 week day.

I tried 2 different formulas but one work from monday to thursday and the other one works only on friday.

So yeah basically I need the good formula for today + 1 week day.

Thanks

I have the same question (0)

All responses (11)

Answers (0)

JAngle 119 on at

Like (1)

Report

RE: Permanent date filter for orders today + 1 week day

What is the date calculation you've tried?

For example: 'T..t+1D'

Was this reply helpful? Yes No
gmoreau 5 on at

Like (0)

Report

RE: Permanent date filter for orders today + 1 week day

I've tried this

<=t&<>'' | <WD1> this works on friday. but not other days of the week

and

<=t&<>'' | <1D> This works from Monday to Thursday

Just tried t..t+1D it does not work

Was this reply helpful? Yes No
ManishS 86 on at

Like (0)

Report

RE: Permanent date filter for orders today + 1 week day

Which field are you entering the formula ? How do you identify your orders are due.

Was this reply helpful? Yes No
gmoreau 5 on at

Like (0)

Report

RE: Permanent date filter for orders today + 1 week day

I enter the formula in the field where I need the date to be today + 1 week day. all orders have dates but I just want to see the ones due today + 1 week day.

We do not identify they are due in any way When a clerk enters an order, they put a date. It's just a filter to only see the ones that are dated with today + 1 week day.

I've tried multiple things using this page : https://docs.microsoft.com/en-us/dynamics-nav-app/ui-enter-data

but nothing can make it work.

Was this reply helpful? Yes No
Suggested answer

Jyotsna NAV 585 on at

Like (1)

Report

RE: Permanent date filter for orders today + 1 week day

Not sure if this is what you want but try this:

CALCDATE('<+1W>',TODAY)

Refer: docs.microsoft.com/.../calcdate-function--date-

Regards

Jyotsna Oberai

Mark my answer as verified if it helped you in any way.

Was this reply helpful? Yes No
gmoreau 5 on at

Like (0)

Report

RE: Permanent date filter for orders today + 1 week day

Hi,

thanks for the reply, but no it does not work.

Was this reply helpful? Yes No
ManishS 86 on at

Like (0)

Report

RE: Permanent date filter for orders today + 1 week day

I tried Today..T+1W, so the filter applied was 29/07/20..05/08/20.

Is this what you are looking for.

Was this reply helpful? Yes No
gmoreau 5 on at

Like (0)

Report

RE: Permanent date filter for orders today + 1 week day

Hi,

no this is not what I'm looking for.

This is not even working for me. I get an error message with this formula.

What I'm looking for is Today + 1 day (monday to friday) excluding saturdays and sundays.

Was this reply helpful? Yes No
Suggested answer

Teddy Herryanto (Th... 14,199 Super User 2025 Season 2 on at

Like (1)

Report

RE: Permanent date filter for orders today + 1 week day

Your date filter does not make sense.

If you want to filter any order that is due tomorrow, you just need to do like this.

..+1D

There is no need to use "or".

If you want to exclude weekends, there is no way to simply do this on date formula because you can't put conditional on date formula.

The only way is to code and assign the date formula based on the condition. Something like: if today is friday, filter until monday. else filter +1 day.

Was this reply helpful? Yes No
Suggested answer

Renni 960 on at

Like (0)

Report

RE: Permanent date filter for orders today + 1 week day

It would be M..F

This gives me 06/07/20..10/07/20

Was this reply helpful? Yes No