Skip to main content

Simple formula of date from and date to in the same box

  • February 9, 2020
  • 1 reply
  • 7 views
C

Hi Newbie here and I am pretty sure I will be a constant bother as I have fallen in love with airtable but not my brain quite so much
so I need a formula for Date from - Date to, just the same as on an invoice where I have covered the dates of the invoice. I have yet to try to the actual invoices on forms

thankyou

    1 reply

    Kamille_Parks11
    Forum|alt.badge.img+27

    Assuming you have a date field for both, you can make a formula field to combine the inputs like so:

    IF(AND({date Fom}, {Date To}), DATETIME_FORMAT({Date From}, 'YYYY/MM/DD') & ' - ' & DATETIME_FORMAT({Date To}, 'YYYY/MM/DD'))

    The formula asks “Have both dates been filled in? If so, write the date like 2020/02/09 - 2020/12/01”

    Terms & ConditionsAccessibility statement