topic calculate first day of week in date Format in Dashboards & Analytics Discussions

calculate first day of week in date Format

Venkat — Thu, 20 Mar 2025 05:05:59 GMT

Hi ,

I have 'Year' column, 'Week Number' with respect to the year, 'Day' number column(i.e. 0 for Sunday,1 for Monday,2 for Tuesday,..6 for Saturday).I need date format using these 3 columns.
Any help on the date column achieving using Year, week Number. Actually I need functionality of same like WEEK_GET_FIRST_DAY FM in SAP i.e. weeks first days date (Sundays date).

Thanks

Venkat

Re: calculate first day of week in date Format

Venkat — Thu, 20 Mar 2025 07:11:49 GMT

Hi,

I have followed the below steps.

i)First, I converted the year column to the starting date of the year using the following Date formula:

date(

concat(

string(<Year Column>),'-01-01'

)

ii)Next, I used the addDays formula to get the derived Date column by multiplying the Week with 7:

addDays(<Above Derived Date column>,double(<Week Number>) * 7)

iii)Finally, using the WeekStartDate formula, I got the Week Start Date with the derived Date Column:

weekStartDate(addDays(<Above Derived Date column>,double(<Week Number>) * 7))

Thanks

Venkat

Re: calculate first day of week in date Format

dylanwan — Thu, 20 Mar 2025 10:52:08 GMT

Thanks for sharing. I guess that you have resolved your issue.