### Title

Programing date field showing when Payment should be done and that can change depending on date

### Post

Hi, I would like to calculate a field that shows when next payment (each week, month, etc) should be made...

I have a "First Payment Field" which is entered manually and I would like to have a "Next payment" field that can be updated automatically depending on current day.

**WEEK CASE**

**First payment: **Oct 10, 2014

**Next payment: ** Oct 17, 2014 (First Payment +7)

When current day = Oct 17, 2014 I would like Next payment to change to Oct 24, 2014 (Next Payment +7) and then When current date is 24th, Next payment should be 31st, and so on.

Thank you

If you define Next payment with this calculation:

First Payment + 7

and select a date result type,

It will compute a date 7 days into the future from the date in First Payment. This requires that First Payment be a date field and not a text field.

Dates in date fields can be thought of as number fields that store the number of days from 12/31/0000 to the date shown in the field so you can compute new dates by adding or subtracting a number of days to/from that date.