Variable error

[neetu_singh]

Dear All,

Can some one help me on this, i am using a variable for max date but when i call this variable into pivot table its not working & if i used expression which is mention in variable is working fine as vMaxDate =  date(max(CommonDate,'DD/MM/YYYY')). please find the below screen shot this expression is not working into variable & i need this into variable as i have to use this into set expression.

Regards

Neetu Singh

[#2]

Make sure in your expressions that variables are coded as below.

$(vVariable)

Stephen

[neetu_singh]

yes, m using the same.

[neetu_singh]

Actually, i am selecting year = 2012 & month = apr, its taking max date = 30/04/2012 which is ok.

But, if one user makes his entry on 21/04/2012. so, for this particular user max date should be '21/04/2012' instead of '30/04/2012' but its giving me '30/04/2012.

'

[chriscammers]

Did you use "let" or "set" to define the value of the variable?

[neetu_singh]

no, m defining this variable on frontent in document setting - variable tab

[#7]

What happens when you put the formula into a text object?

I just checked this on a document and works fine for me - I would check your data in the field...

[#8]

When you created the variable put the = sign before the expression in the field definition?

[jonathandienst]

Hi

Are you saying that you want the max date to show the last date for the current user?

If so, then you will need to have some association with the username of the current user, or an if statement in the variable to check the dates againt the current user name. The best solution depends on your data model and it would be helpful if you could post your model or a sample of it.

Regards

Jonathan

[neetu_singh]

these two fields "user" & Date are coming from the same table.