Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, in order to sort my datas, I'm using different selection lists with the years, the months and the weeks. Moreover, I would like to use two input field where the user can determine himslef the period of calculations.
Therefore, I would like that when the user select, let say, a week in the selection list, that the two variables of the input fields adapt themselves to the new selection with min and max values. How could I proceed?
Thanks!
Here are the files, I will check what I did wrong, and I find how, I'll let you know
Cannot download.
Its corrupted.
Regards
ASHFAQ
Oh that's strange. Maybe with this one
Well I don't undertstand 😕 I did exactly the same as in the videos and it stille doesn't work
All my dates are in a format DD/MM/YYYY in the field "JD_DATE" and my two variables are called:
- vDateDebMiseProd (start)
- vDateFinMiseProd (end)
I added those triggers:
Field: "JD_DATE"
Search string: ='>=' & vDateDebMiseProd & '<=' & vDateFinMiseProd
I don't know why it doesn't want to work. In order to see if it worked, I used a single table with the fiels JD_DATE so all the dates are shown but it doesn't change when changing the variables.
Do you think it can come from the script? I'm actually using the master calendar in it so in my selection list, I'm using these fields:
week(TempDate) As JD_Week
Year(TempDate) As JD_Year
Month(TempDate) As JD_Month
Day(TempDate) As JD_Day
When I select, let say a week, it works perfectly, but with the variables, not
Hi,
See if your variable values are same format DD/MM/YYYY.
I usually have the key field in my calendar Numeric and my variables numeric.
both have to be same format
In my script, I have: both SET DateFormat='DD/MM/YYYY' and date(ENDV_DATE, 'DD/MM/YYYY') as JD_DATE and my variables are set as dates DD/MM/YYYY in their properties
I still cannot open this files.
Regards
ASHFAQ
attached sample file using your qvd data.
I built from scratch as your app Data model is full of synth keys.
Please note of the variables and trigger associated.
Hope this helps.
JP