Skip to main content

Hello there!


I have made an text field where you can enter a date with a “/” or can input only a week. Only problem is now that because the year is in a seperate column it is hard to get a full date when the record doesn’t have a / and get a full date when the record only has an week. Also the timezone in airtable is american by default but i need european.


Hi @Vito_Kloots , I’ve put something together here that I think does what you’re looking for, and you can duplicate the base to view the formulas



Here’s the formula for your convenience:


IF(

  FIND("/", {Week / Date}),

  DATETIME_PARSE(

    {Week / Date} & "/" & Year,

    "DD/M/YYYY"

  ),

  DATEADD(

    DATETIME_PARSE(Year, 'YYYY'), 

    VALUE({Week / Date}) * 7, 

    'days'

  )

)

We can set the date display format to European via the Formatting tab within the field itself, or at least I think this is what you mean? Apologies if I’ve misunderstood

Reply


Terms & Conditions