Announcements
Hi,
I'm on NAV2018. I'm trying to create a saved sales order list. I'm trying to enter a filter that will always return today's sales orders, based on the document date.
If I enter w or t, it translates to today, but that does me no good when the day changes.
I've seen posts to use (Day(0)), but I get an error saying "A ) " is missing.
Can anyone help?
I need a filter to stick, so only today's orders show, because I want this to be a saved list.
Thanks,
Steve
*This post is locked for comments
You should be able to use either TODAY or WORKDATE on your code.
SETRANGE("Document Date",TODAY);
Hi,
If you are a developer, create a global variable and set its vale as TODAY. After that use that variable in list page property and apply the filter.
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156