Amanda_Finkelbe - profile

Amanda_Finkelbe · Jul 24, 2018

I’m trying to make my “group by week” formatting easier to understand by showing the date range for the week rather than the week number but can’t seem to get the formula that works in Excel to work in Airtable-- has anyone figured this out? Thank yo...

Amanda_Finkelbe · Jul 25, 2018

Very helpful answer-- I really only wanted to group by {weeknum} but display the date range on the collapsed field (looks better) but will have to make do with one or the other, it seems.

Amanda_Finkelbe · Jul 25, 2018

W_Vann-- any idea how to get around this? I’m making a time card view

Amanda_Finkelbe · Jul 25, 2018

W_Vann_Hall: DATETIME_FORMAT( DATETIME_PARSE( {WeekNum}&’’, ‘w’ ), ‘M-D-YYYY’ )& ’ – ‘& DATETIME_FORMAT( DATEADD( DATETIME_PARSE( {WeekNum}&’’, ‘w’ ), 6, ‘days’ ), ‘M-D-YYYY’ ) Beautiful! Worked like a charm. Thank you so much1

User Statistics

User Activity

Converting WEEKNUM to date range?

Re: Converting WEEKNUM to date range?

Re: Converting WEEKNUM to date range?

Re: Converting WEEKNUM to date range?