Jump to content

Find in a Portal Field


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

Recommended Posts

I have two files. Sites and Letters. The site file has fields with computer information in the fields. There is a Site Name field, System Type field, MaintExDate and a Computer Serial Number field. On site or "Site Name' could have 12 records (12 computers at that site).

The Letters file has a portal in it that has the related System Type, Compuer Serial and MaintExDate in it. The relationship is based on the unique site names.

So the Letters file displays a Site name and in the portal all the computer systems related to that site.

Based on the maintenance expiration date (MaintExDate) I want to only display in the portal those systems that have or will have in the next three months MaintExDate expired so I can send them a letter. I have tried to search the MaintExDate but if any of the dates are valid all the system serial numbers show up. I also tried omitting the valid dates but then all the records in the portal were omitted.

Is the answer to use a global with the date range in it and then find on the MaintExDate?

All help appreciated...

Link to comment
Share on other sites

This topic is 7753 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.