Filtering flow fields with Date

mb6606
mb6606 Member Posts: 30
edited 2011-12-12 in NAV/Navision Classic Client
Is it possible to filter a date flow field?
Sum("Sales Line"."Outstanding Quantity" WHERE (No.=FIELD(Style),Document Type=CONST(Order),Shipment Date=xxxxxx))

I want the shipment date to be a date range example 09/01/11 to 09/30/12
or possibly Today +30 days??

Thanks

Comments

  • David_Singleton
    David_Singleton Member Posts: 5,479
    mb6606 wrote:
    Is it possible to filter a date flow field?
    Sum("Sales Line"."Outstanding Quantity" WHERE (No.=FIELD(Style),Document Type=CONST(Order),Shipment Date=xxxxxx))

    I want the shipment date to be a date range example 09/01/11 to 09/30/12
    or possibly Today +30 days??

    Thanks


    This is how just about every flow field in Navision works. What is the issue.
    David Singleton
  • Savatage
    Savatage Member Posts: 7,142
    For your range -
    In the Table Filter of your Flowfield:

    (Field)Shipment Date
    (Type)Field
    (Value)Date Filter
    Sum("Sales Line"."Outstanding Quantity" WHERE (No.=FIELD(Style),Document Type=CONST(Order),Shipment Date=FIELD(Date Filter))
    Style? Custom Field?

    So when you Shift-F7 - you'll Add "Date Filter" to the list of flowfilters.
    enter a range & see what happens
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org
  • mb6606
    mb6606 Member Posts: 30
    I need to revisit this we are passing this data to a website using Page.

    "Sum("Sales Line"."Outstanding Quantity" WHERE (No.=FIELD(Style),Document Type=CONST(Order),Shipment Date=xxxxxx))
    I want the shipment date to be a date range example 09/01/11 to 09/30/12
    or possibly Today +30 days??"

    I cannot set the flowfilters manually using
    "So when you Shift-F7 - you'll Add "Date Filter" to the list of flowfilters.
    enter a range & see what happens"

    It needs to be done automatically within the CALCFORMULA property of the field in the table.
    I have not found a solution searching online.
    Thanks in advance

Categories