Jump to content


  • Posts

  • Joined

  • Last visited

cbouse's Achievements


Apprentice (3/14)

  • First Post
  • Collaborator
  • Conversation Starter
  • Week One Done
  • One Month Later

Recent Badges



  1. disregard, i got it. its "+" not "-"
  2. Lee, You assumed correctly. I wanted to generate a report that will give me a list of people that will expire in the next 30 days and 60 days but don't want the same people to show up in the reports, (don't want the 30 day people in the 60 day report). Thank you so much for the reply. If you don't mind, im trying to learn this for myself so what is the difference between the two and which one is better? I tried the easier script but couldn't get it to work. It just tells me that there are no results. Enter Find Mode [] SetField [membership_information::membership_expiration_date; Get(CurrentDate)-60&"..."&Get(CurrentDate)-30 Perform Find [] Thanks again, Chris
  3. sorry, here is the simple script i got with the help of someone else; "≤ " & Get ( CurrentDate )+30 "≤ " & Get ( CurrentDate )+60
  4. I have a database that records membership information including a membership expiration date. I wrote three simple scrips that find expired members, members that will be expired in 30 days, and members that will be expired in 60 days. I need to figure out the scripting to exclude the people that have expired for the expiring in 30 days list, and to exclude the people that have expired and the people that will expire in 30 days from the expires in 60 days list. can someone please help with the script to do this.... Thaks
  5. that's great, thanks, ill give that a try. thanks again for the help
  6. sorry, like i said, NOVICE. maybe i just need greater help than a forum can offer me....
  7. creating a record of all dates entered?
  8. hey all, beginner using version 8.5 advanced. doing some work for a non-profit group with membership date problems. I currently have three date fields im working with; date first joined renewal date expiration date im doing a very basic script that looks at the date first joined and adds 365 days to it and puts that value in the expiration date field. if there is a value in the renewal date i want that to take priority and then add 365 days to that date and put that value in the expiration date field. The date first joined turns into historic data only after the first year. Im not sure if anyone has an advanced calculation that they wouldn't mind giving me, cant pay for it, this is for non-profit, but the ideal situation for this calculation would be to have the date first joined, (this field just turns into historical info after the first expiration date) some sort of selector that would allow someone to renew a membership for multiple years, a renewal date field, and an expiration date field. this would allow someone who just joined to pay for multiple years giving me a proper expiration date. The membership is for one full year so it would have to consider how many days are left in the year, not sure about leap years??? But people who renewed would also need the same option. Im not that smart so im just doing the good old "take this day and add 365 days to it". That will work without being too fancy, but if anyone can help me out that would be great.... Thank you, Chris
  9. Sorry it took so long for a reply, work is kicking my butt... You brought up some good points, like i said, still a novice at this so its hard for me to see all the angels. The date first joined will never change. Its more of a historical date to keep track of how long someone has been a member. Its only used for the first year of a membership and that's really it. After that, the date renewed is the only field altered after that and the calculation for the expiration date field comes from that date. Keeping a record of renewal date and amount is exactly what i am about to start working on. Looks like you already got me started. I REALLY appreciate the help with this. If you have any further guidance / suggestions, PLEASE, let me know... Thanks again, Chris
  10. I was just thinking how i kinda need to elaborate on my problem. So i come in and sign up for a membership and that populates the date first joined. That needs to automatically put a date in the membership expiration field which is 365 days past the date in date first joined field. When my membership expires ill come in and renew, hence the date renewed field. That needs add 365 days to the membership expiration field giving me a new year. The big problem is what if i come in and pay my membership before my account expires, (i.e. im out of the country and want to pay a month or two in advance to renew my membership. So now i have to find out how many days are remaining in the year and add to the 365 days. And we just started thinking about leap years and stuff.... Im a novice just trying to help a non-profit group and this is way over my head... Thanks again for taking the time to help
  11. Thank you for the quick post. The hard part i need on this calculation is the pro rated part. so if i have a membership that was created on 01/01/09 it expires on 01/01/10, easy but if my member decides to renew on 11/01/09 and not 12/31/09, i need the expired date to take the remaining days of that persons membership and add them to the new renewal term. Thanks again for the quick reply and welcome.... :
  12. Hi all, I searched around but couldn't really find a calculation that helped. I have a database for membership to a shooting range. There are three date fields I need to work with, (date_first_joined, date_renewed, date_membership_expired). when a new record is created the expiration date needs to be the date joined +365 days, simple. when i enter a date into the date renewed field, I need the expiration date to look at that date and calculate a year past the date renewed and add the remaining days in the year to it to give me a new expiration date. Been trying for a while but just cant get it. Thank you in advance for the help.....
  • Create New...

Important Information

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