How to unpack date variable

[ananth]

I have a date variable stored as =Num(Date#('2025-11-01','YYYY-MM-DD')).

How do I use this variable to filter values?

For example, I want to take the sum of amount of all entries where date is before this particular date variable.

I am using this as my expression:

Sum(
{
<
Date = {"<=$(=Num(vMinClosedDate))"}
>
}
Amount
)
but it evaluates to zero.

[MatheusC]

Review your formatting. An important point is that if your variable has a certain format, the field associated with that filter (variable) must also be in the same format — in your case, the Date field.

- Regards, Matheus

[Vegar]

@ananth I think you're just missing a $-expansion. Try this:

Sum({<
Date = {"<=$(=Num($(vMinClosedDate)))"}
>}
Amount)