Adding x weeks onto a date field

[contactme]

Newbie, sorry if already answered.

I have an appointment booking system for clients, who have set frequency between visit in weeks.

I know the last visit date, and the frequency in weeks, but how do I calculate the next due date?

At the moment I have used +days to add the frequency as days,.

but I need it in weeks. I cant see a way of displaying or calculating the number of days converted from weeks, I cant see a simple way to multiply weeks x 7 to give days to add to the last visit date to give the next date.

Hope someone understands and can help. TIA

[adamhholmes]

You probably need to turn on parentheses - then you can just multiple the weeks by 7 (assuming you can’t already).

Alternatively just store the frequency in days instead of weeks.

[connect10]

@contactme

At the moment I have used +days to add the frequency as days,.

but I need it in weeks. I cant see a way of displaying or calculating the number of days converted from weeks, I cant see a simple way to multiply weeks x 7 to give days to add to the last visit date to give the next date.

Hope someone understands and can help. TIA

Hey! You can calculate it by just multiplying the weeks by 7. For example: Last Visit Date + (Frequency in Weeks * 7) days. That will give you the next due date easily.

[contactme]

Thank you