SetRange with Date

arindam
arindam Member Posts: 176
edited 2008-01-02 in NAV/Navision Classic Client
Hi Guys,

Merry Christmas in advance !!!!

I am having a simple problem. In my table I have a date type feild. From my search from I need to list all data within a date range.

I am using Setrange function of Navision. Can you please tell me what syntax shall i was trying with the syntax :

SETRANGE(DocDate,>=strStartDate & <=strEndDate);

DocDate is date type , also strStartDate and strEndDate are date type.

Please help.

Thanks and Regards,
Arindam

Answers

  • NaviDev
    NaviDev Member Posts: 365
    If you are filtering with range you can use either setrange or setfilter.

    ex.
    SETRANGE(DocDate, StartDate, EndDate);

    SETFILTER(DocDate, '%1..%2', StartDate, EndDate);
    Navision noob....
  • arindam
    arindam Member Posts: 176
    Thank you.

    This solves my problem

Categories