Help

Create date with timezone from week or date

Topic Labels: Formulas
Solved
Jump to Solution
1227 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Vito_Kloots
4 - Data Explorer
4 - Data Explorer

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.

Screenshot 2022-09-05 at 14.38.04

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

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

Screenshot 2022-09-05 at 8.59.30 PM

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
Screenshot 2022-09-05 at 9.00.17 PM

See Solution in Thread

1 Reply 1
TheTimeSavingCo
18 - Pluto
18 - Pluto

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

Screenshot 2022-09-05 at 8.59.30 PM

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
Screenshot 2022-09-05 at 9.00.17 PM