Date comparision with variable

[#1]

Dear All,

I defined variable as ANALYSIS_DATE type date; I have field as TDate; I want to sum AMOUNT which is below the ANALYSIS_DATE;

My expression: =sum(all (if(TDate < max(ANALYSIS_DATE), AMOUNT)) is not working; please guide me.

Thanks

Eshack

[#2]

can you try this

=If(TDate < max(Analysis_date), sum(Amount))

-Raghu.

[#3]

Hi,

Try out this below expression

=sum(all (if(TDate < max(total ANALYSIS_DATE), AMOUNT))

- Sridhar

[Anonymous]

Eshack,
If the ANALYSIS_DATE is a variable, I don't understand the need of max(). So, this should be enough
=sum(all (if(TDate < ANALYSIS_DATE, AMOUNT))
Make sure that the format of Date and ANALYSIS_DATE are both date or number.
(I don't see the need of "all" qualifier in this case, but hope you know what you're doing.)

[Oleg_Troyansky]

I found Date comparizon quite tricky, because of the dual nature of Dates. I'm usually casting them to numerics, just to make sure that I'm comparing the same values:

if( num(Date1) = num(Date2) ...

Oleg