i am looking to make statements. i have a few different dates i need the program to figure out.
firstly, a person can be billed for 1,2,3 or 6 months at a time. that info will be in the table as numbers.
i want the program to figure out the effective dates, ie: if he is billed for 1 month at atime i want the program to say
July 1, 2001 - August 1, 2001. If he is billed for 2 months, it should say July 1, 2001 - September 1, 2001. etc.
i cannot write an if statement saying if [pmt]=1,then days = 30, because some months have more or less than 30 days.
i want the computer to figure out what is 1 or 2 months into the future. and write it out as words, not numbers.
any suggestions?
firstly, a person can be billed for 1,2,3 or 6 months at a time. that info will be in the table as numbers.
i want the program to figure out the effective dates, ie: if he is billed for 1 month at atime i want the program to say
July 1, 2001 - August 1, 2001. If he is billed for 2 months, it should say July 1, 2001 - September 1, 2001. etc.
i cannot write an if statement saying if [pmt]=1,then days = 30, because some months have more or less than 30 days.
i want the computer to figure out what is 1 or 2 months into the future. and write it out as words, not numbers.
any suggestions?
