News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics NAV (Archived) Date filteration in NA...

Microsoft Dynamics NAV (Archived)

Date filteration in NAV 2013

(0) Share

Report

Report

Posted on by manish.yadav

1,835

Hello Experts,

I want to set the filter for before 4 days. I am unable to do it in nav.

I am trying with

recSalesHeader.SETRANGE("Document Date",4D,TODAY);

but it is showing the error messages.

manish

*This post is locked for comments

All responses Img

All responses (5)

Answers Img

Answers (1)

manish.yadav 1,835 on at

Like (0)

Report

RE: Date filteration in NAV 2013

thank u sir,

it is working

manish
Binesh 7,885 on at

Like (0)

Report

RE: Date filteration in NAV 2013

Hello Manish,

Use this line

recSalesHeader.SETFILTER("Document Date",'%1..%2',TODAY-4,TODAY);
Suggested answer

Alexander Ermakov 28,094 on at

Like (0)

Report

RE: Date filteration in NAV 2013

Agree with other members, CALCDATE function should suit your needs:

msdn.microsoft.com/.../dd301368(v=nav.70).aspx

using also TODAY function:

msdn.microsoft.com/.../dd301338(v=nav.70).aspx
Amol Salvi 18,694 on at

Like (0)

Report

RE: Date filteration in NAV 2013

Check the CalCDate Function

msdn.microsoft.com/.../dd301368.aspx
Verified answer

Rajasekhar@MS 5,567 on at

Like (1)

Report

RE: Date filteration in NAV 2013

Hi

Have a look at CALCDATE function (or you can use TODAY-4) in Navision to get the required date and you can apply the filter.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,235 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans