Jump to content
Sign in to follow this  
Mountain Biker Two

Update date

Recommended Posts

This must be a common problem, but I don't quite know where to look.

I create lists of our members whose memberships have expired. I do this on an irregular schedule. I want to log this date (manually is fine, since it may actually take several days). I would like to keep a record of all these dates.

I also want to do calculations based on the latest (or next to latest) date. For example, all members who have gone deliquent since last updating. (But to be safe I'd probably want to enter the current date in before I create the list to make sure I don't forget).

I tried creating a global variable in the main database. I then created a related database with two fields. A sequence number and the date. I then tried bringing the dates into the main database with a portal. I was able to create a portal, but nothing shows up. I'm not too familar with global records nor portals for that matter.

Must be tutorial or something on this. I have the Schwartz book, but can't figure out where to look.

Thanks for any help.

Share this post


Link to post
Share on other sites

What are the two databases related on? Is the date I suppose? What's the name of this relationship?

Also, what was in the global variable that you created?

Share this post


Link to post
Share on other sites

In the main database, a global variable named "ListDate." This was meant to be the variable to display in the main database.

The secondary database has two fields. A sequence number (not sure if needed) and a date. 1 is 3/26/2003, 2 is 5/1/2003, and 3 is 6/13/2003.

"ListDate" is related to "List Date" in the secondary database.

Thanks Paul

Share this post


Link to post
Share on other sites

MBT,

Can you explain what you want to do a bit more in detail?

If you're trying to subtract "date of expiration" from "current date", just make:

"current date" => Today, calculated field, date

"date of expiration" => manually entered, date

"Difference" => Current Date - Date of Expiration, calculated field, number

This will give you the difference in days.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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