
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 05, 2022 05:38 AM
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.
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 05, 2022 06:01 AM
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 05, 2022 06:01 AM
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
