increment dates

[mogaka]

i am creating an invoice creation project where every client has a certain date for payment per month. how do i put the system to update next payment date e.g if client x is supposed to pay on 6th every month and has paid for april,the system should automatically update the sql server database to indicate the next pay date to be 6th may?

[adam_k]

using dateadd function. Read about it here: http://msdn.microsoft.com/en-us/library/ms186819.aspx