Jump to content

Portal Filtering Using Global Date Fields


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

Recommended Posts

  • Newbies

Hi everyone. I am new to posting so hopefully I will be able to get my issue accross effectively.

I have a portal that gives me a group of all open invoices. One of the fields in the portal is a follow up date (NextCall). I have two global fields in the header. One is a start date and one is an end date (GlobalStartDate and GlobalEndDate).

My calculation for the filter is NextCall >= GlobalStartDate AND NextCall <= GlobalEndDate. This works fine when I switch from layout view to browse view however when I change the global dates, the portal records won't refresh. But if I go to layout mode then back to browse mode, the records are refreshed. I have tried a few things such as reseting the global fields and committing the records and refreshing the screen, changing modes but nothing except going to layout and back to browse seems to work.

I made sure that the NextCall field is indexed and is a date field and have also checked the global fields to make sure that they are dates as well.

Please HELP!! :)

Link to comment
Share on other sites

This topic is 4724 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
×
×
  • Create New...

Important Information

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