Calender Dates

[manoj217]

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

[manoj217]

One calendar dependent on two fields is possible

can we create a calender object on two variables for start date and end date ?

[Anil_Babu_Samineni]

Play around using MonthStart(DateField) from Object expression?

[manoj217]

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

[Anil_Babu_Samineni]

Can you give sample data, Explain please for me?

[manoj217]

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

[Anil_Babu_Samineni]

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])

[uacg0009]

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

[bvssudhakar]

Hi Manoj,

Can you share your qvd. so that i will try to solve your issue

Thanks & Regards,

Sudhakar

[manoj217]

Yes Zhao your assumption is correct i want the same