Calendar problem

[saumyashah90]

if i want to add date condition in calclated dimension for field name Dt

what should be my expression?

I have D

Dt={'>=$(Start_Date <=$(End_Date)' }

[sushil353]

Use

Dt={">=$(Start_Date) <=$(End_Date)'"}

[Gabriel]

Hi,

even though am not sure I fully comprehend your question, however, I will suggest you wrap your expression up in IF function.

Also, if you can possibly explain more in details what you want, might be helpful to the communnity.

Regards,

Gabriel

[saumyashah90]

Its not showing any thing...expression is also not ok

[saumyashah90]

See we have calendar option in which we have two variables Start_Date nd End_Date ,Now we are using a straight table in which there is one dimesion as "Dt"

So we want this dimesnion to fall in between those calendar conditions or range i.e Start_Date & End_Date.

[er_mohit]

try this

= '>=' & vStartDate & '<=' & vEndDate

here,vStartDate and  vEndDate is my variable

[jagan]

Hi Saumya,

Try like this

=Aggr(If(Dt >= Start_Date AND Dt <= End_Date, Dt, Null()), Dt))

Hope this helps you.

Regards,

Jagan.