Filtering flow fields with Date

mb6606

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

David_Singleton

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.

Savatage

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

mb6606

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