Filtering flow fields with Date

mb6606mb6606 Posts: 30Member
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_SingletonDavid_Singleton Posts: 5,454Member
    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
  • SavatageSavatage Posts: 7,140Member
    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
  • mb6606mb6606 Posts: 30Member
    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
Sign In or Register to comment.