Create date with timezone from week or date

[Vito_Kloots]

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.

[TheTimeSavingCo · Accepted solution]

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