Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Dear All,
Its done, for this we need to create a ledger by using peak function at the backend then if user have done last entry on 21/04/2012 then from 21 to 30/04/2012 it will give the same value using peak function.
So its resolved.
Thanks for all your support.
Regards
Neetu Singh
Make sure in your expressions that variables are coded as below.
$(vVariable)
Stephen
yes, m using the same.
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.
'
Did you use "let" or "set" to define the value of the variable?
no, m defining this variable on frontent in document setting - variable tab
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...
When you created the variable put the = sign before the expression in the field definition?
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
these two fields "user" & Date are coming from the same table.