Skip to main content

Hi,

I have an accommodation business, I am trying to calculate a due date for the final payment which is based on the number of days (generally 60) prior to their arrival date. I appreciate any assistance.

Thanks!

Hi @Jill_Engledow,


Welcome to the Community! Thanks for posting 🙂


To calculate a due date based off an arrival date field, I would recommend using a formula field with the DATEADD() function.


For example, you could a formula similar to: DATEADD({Arrival Date}, -60, 'days') which subtracts 60 days from the date in the “Arrival Date” field. Please note, you may need to change this to match the field name in your table if you try this formula.



Here is our Formula Field Reference for more information.


Hope this helps!

Hi @Jill_Engledow,


Welcome to the Community! Thanks for posting 🙂


To calculate a due date based off an arrival date field, I would recommend using a formula field with the DATEADD() function.


For example, you could a formula similar to: DATEADD({Arrival Date}, -60, 'days') which subtracts 60 days from the date in the “Arrival Date” field. Please note, you may need to change this to match the field name in your table if you try this formula.



Here is our Formula Field Reference for more information.


Hope this helps!


Thanks so very much!! That worked perfectly.

Jill

Thanks so very much!! That worked perfectly.

Jill


Happy to help, Jill 🙂


Have a great day!

Reply


Terms & Conditions