Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
i have a calender object in my dashboard and i have 2 date fields like paid date and received date.
Now i am created a calender object based on paid date but user mentioned if he selects a start date in the object it should shows the data from 7 days before of his selection so i mentioned (paid date)-7 its working fine but he mentioned received date data should be in the range of his selection only
example:
if i select date range 7/10/2018 means paid date data should be 1/10/2018
but received date data in 7/10/2018 to current date only
One calendar dependent on two fields is possible
can we create a calender object on two variables for start date and end date ?
Play around using MonthStart(DateField) from Object expression?
sorry it will not work my requirement is different
i have calender object if we select any date document will hold the data regarding those selections.
but if user select today as min date but i have to show before 7 days data it is working. it is created on one field payment date
but now i want to show the data on current selected date in another field received date
Can you give sample data, Explain please for me?
paid date received date
10/12/2018 12/12/2018
13/12/2018 14/12/2018
14/12/2018 16/12/2018
15/12/2018 18/12/2018
17/12/2018 20/12/2018
20/12/2018 25/12/2018
if user selects a date 20/12/2018 but in document shows data from 14/12/2018 -----this data from paid date field
that means
14/12/2018 16/12/2018
15/12/2018 18/12/2018
17/12/2018 20/12/2018
20/12/2018 25/12/2018
this data will show in output but i want to show only
17/12/2018 20/12/2018
20/12/2018 25/12/2018
You can try this way? Where as your problem comes thru Calendar. Better if you can share sample application
If([paid date] >= [receive date], [paid date])
Hi manoj,
do you mean when you select 20/12/2018,
you want to show all the results that paid date >= 14/12/2018 and received date >= 20/12/2018?
if yes, I can handle this. if no, please help to clarify the logic.
Thanks.
Aiolos
Hi Manoj,
Can you share your qvd. so that i will try to solve your issue
Thanks & Regards,
Sudhakar
Yes Zhao your assumption is correct i want the same