Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to create a button action that will select the five latest dates loaded, using:
Max(DateField)
Max(DateField,2)
Max(DateField,3)
Max(DateField,4)
Max(DateField,5)
I know that in the Search String I can list out items like this: ("Date1"|"Date2"|"Date3"|"Date4"|"Date5")...
But what I'd like to do is list out the five expressions like this instead, and I haven't been able to get the syntax figured out. I know that I can make five separate select actions, but I would really like to get them into one. Is there a way to do this? I appreciate your help.
Hi,
Not sure but you can try this,
='("'& Max(DateField) &'"|"'& Max(DateField,2) &'"|"'& Max(DateField,3)&'"|"'& Max(DateField,4)&'"|"'& Max(DateField,5)&'")'
Regards,
Kaushik Solanki
Hi Nate,
maybe Select in Field
='>='&Max(DateField,5)
Regards,
Antonio
Might make sense to add {1} in set analysis
='>=' & Max({1} DateField, 5)
Or if selections needs to be honored, then this
='>=' & Max(DateField, 5) & '<=' & Max(DateField)
Hi think not needed because <=Max(Field) Always verified. however they don't hurt.
Perfect, thank you!
Thank you! Both of these worked as well.
Are you going to be using this without any selection being made? Or is this can be based on selection made....?