Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
gkcchowdary
Creator
Creator

Tell me below requirement?

Hi,

I have to provide input box to the user.

If user enter any date in the input box and automatically select in month in month list box or chart.

Ex: user enter 10/06/2017 in input box it automatically select Jun month in other month list box. How to achieve this?

2 Replies
Anil_Babu_Samineni

For this, you can achieve like. Please handle one variable called as Variable1

Then, In list box, you can call it as expression to =If(DateField = Variable1, MonthField)


If it is in straight table, You could state that variable as Sum({<DateField = {"<= Variable1"}>}Sales) // Here, You can manipulate if date format issue

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
vishsaggi
Champion III
Champion III

One way is you can use triggers to select the Month field with the date entered in the Inputbox.

Create a variable using Inputbox. Then using your monthfield add a trigger from Doc Properties ctrl+atl+D then variable event triggers select the variable created from inputbox.

Capture.PNG