Max Date

[#1]

I'm trying to set the =date(max(Date) equal to or less than the =date(Today()). The date needs to stay dynamic but not exceed todays date because it messes up my calculations. Tried multiple IF statements and been unsuccessful.  The reason for that is it uses the [Bill Date] and not the selected date. and returns a False statement. Below is the expression I'm currently trying. This software is still new to me. Any and all help will be most welcomed.

sum( 
{$<
   [Bill Date]  = {"<=$(=date(max([Date])))>$(=date(max([Date])-90))"},
    [Year]=,
   [Period]=,
   [Date]  = {"<=$(=date(Today()))>=$(=date(min(Date)))"},
    [Month]=,
   [Calendar Year] =,
  LinkId = {"FIN"}
>}
[Bill Quantity])
/
90

[marcus_sommer]

I think you will need to give more background to your question - maybe within a small example. I wouldn't be surprised if you would need a canonical date to connect both of your date-fields, see: Canonical Date.

- Marcus