Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
May i know how to use the button to select year_ =2012 ?
=num(Year(Today()) -1)
I try above not able to work. any work around ?
Hi Paul,
Check the attached QVW.
you need to use Right function to get it Selected.
Thanks,
Shruthi
Create A button
goto Actions -> Selection -> Select in field -> Year- Search string(2012)
hope it helps..
Hi Paul,
Check the attached QVW.
you need to use Right function to get it Selected.
Thanks,
Shruthi
Hi sir
you code seen to work , but i need the year selected turn green. can you advise me how to make it turn green ?
Hi sir
I need the code that is selection of current year for this year and next year when press the button.
Hi Paul,
you can check the attached QVW in my previous reply.
Since the Year is the listbox is showing oly 2 digits its not selceting.
so if use Right function, it selects and turns green.Hope this solves. similary for current year and next year.
Thanks,
Shruthi
Hi shru
yes i aware your qv doc send me turn green.
But In my actual qv application , i need to make some change of the list box. i need to add :-
=If(Year>1995, year_)
Check my latest doc pls.
Hi Paul,
You are using a listbox with a calculated dimension, check current selections and you'll see that your action button makes a selection in the year_ listbox.
BR
Fredrik