Jump to content

cbouse

Members
  • Content Count

    12
  • Joined

  • Last visited

Community Reputation

0 Neutral

About cbouse

  • Rank
    novice
  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_expirati
  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.
  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
  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 i
  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 j
×
×
  • Create New...

Important Information

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