Date comparison

[#1]

I have a input control which stores date in a variable say vDate. I have two fields Inception Date and Expiration Date. Based on the value in input control I need to get the results in Straight table or Pivot table with the condition Where Inception Date>= vDate and Expiration Date <= vDate.

[#2]

Hi

try this if(Inception Date>= vDate and Expiration Date <= vDate,DimName)

[sushil353]

hi,

If you want to use this condition for an expression then u can use set analysis:

sum({<Inception Date={">=$(vDate)"},Expiration Date={"<= $(vDate)"}>}FACT)

and if you want to use in dimention then you can follow expression as given by nirmal.

if(Inception Date>= vDate and Expiration Date <= vDate,DimName)

HTH

Sushil

[#4 · Accepted solution]

I got this working by using below.

sum({<InceptionDate={"<=$(vDate)"},ExpirationDate={">=$(vDate)"}>}Sales)