help with expression for dates

[jpruezkiez]

hello, i am trying to acomplish an expression that based on a date column, eg: i have my date column is set to 3/5/2023, then my column WEEK would be 2/27 - 3/5, like creating a week range.

i have tried with the following expressions:

CONCATENATE(TEXT(EOMONTH([Pickup Date], -1) - WEEKDAY(EOMONTH([Pickup Date], -1)) + 1, "MM/dd"), " - ", TEXT([Pickup Date] - WEEKDAY([Pickup Date]) + 7, "MM/dd"))

and this one

CONCATENATE( TEXT( ([_THISROW].[Pickup Date] - WEEKDAY([_THISROW].[Pickup Date], 2) + 1), "MM/dd" ), " - ", TEXT( ([_THISROW].[Pickup Date] - WEEKDAY([_THISROW].[Pickup Date], 2) + 7), "MM/dd" ) )