5
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
t..t+1s
:-)
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.
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.
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.
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,409
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
