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" ) )

[Marco_Antonio_N]

This expression filters the current week, see if it helps you

AND (([Data]> = (TODAY () - WEEKDAY (TODAY ()) + 1)), ([Data] <= (TODAY () - WEEKDAY (TODAY ()) + 7)))

[jpruezkiez]

doesnt seem to work, it it's returning a value of true.

[Marco_Antonio_N]

Troque "Data" por "Pickup Date"