Jump to content

Can a Portal be filtered by a Date range?


infoweb
 Share

This topic is 2814 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hi there,

 

I'm trying to find a way to filter a portal by a date range without much success.

 

I realise this can be done using a relationship where the key field is dynamically updated but I'd prefer to use portal filtering (if possible)

 

Here's what I've tried:

 

Vend_Sales_Lines_api::Date = ( ProductSalesReportLines::StartDate & "..." & ProductSalesReportLines::EndDate )

 

(didn't work)

 

Tried a calculated field that contained the date range also:

 

Vend_Sales_Lines_api::Date = ( ProductSalesReportLines::DateRange )

 

Still no luck.

 

Before I keep going I want to see if it's possible to filter by a date range or not.

Link to comment
Share on other sites

Vend_Sales_Lines_api::Date = ( ProductSalesReportLines::StartDate & "..." & ProductSalesReportLines::EndDate )

 

The … range symbol is a Find operator - you cannot use it in a calculation formula:

http://www.filemaker.com/help/13/fmp/en/html/create_db.8.47.html#1030789

 

Try instead:

ProductSalesReportLines::StartDate ≤ Vend_Sales_Lines_api::Date and Vend_Sales_Lines_api::Date ≤ ProductSalesReportLines::EndDate
Link to comment
Share on other sites

This topic is 2814 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.