Filtering flow fields with Date

Comments

• Options

  David_Singleton Member Posts: 5,479

  2011-12-12

  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
  

  0
• Options

  Savatage Member Posts: 7,142

  2011-12-12

  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

  0
• Options

  mb6606 Member Posts: 30

  2019-10-24

  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

  0