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!
Calculate a due date based on number of days prior to arrival date
+2Hi @Jill_Engledow,
Welcome to the Community! Thanks for posting :slightly_smiling_face:
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 :slightly_smiling_face:
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
+2Thanks so very much!! That worked perfectly.
Jill
Happy to help, Jill :slightly_smiling_face:
Have a great day!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.