I've developed a music publishing program and am using dates to calculate days, months and years when songs can be returned to writers. I have all the calculations working fine except the dates are for x-amount of years + one day. The problem is that I don't know how to make the months with 30 days go to the next month and date, and the months with 31 days to go to the next month and next date. (I know there's not 32 days in a month, but I need to fix that.) (I hope you understood that!)
Can you help?
Thanks so much,
For "next month" and "next year" calculations, use the date function:
Say you have a date stored in a field named DateField and you need to compute the next year + 1 day date for it:
Date ( Month ( dateField ) ; Day ( DateField ) + 1 ; Year ( Datefield ) + 1 )
will compute that date and the number of days in a given month will not affect the results--they'll adjust automatically.