how to check date which lies in between two date

[brijeshvma]

Hi All ,

I have a one table in that i have start date and end date . and second table i have where i have one more date ..

I want the dynamic list condition .. it means if user not selected any date so it check , if today date comes in between start date and end

date so its paid else unpaid . but say if user select any date , say user selected 01 jan 2016 . so its start date and end date in which 01 jan date come so those id will be paid else other are unpaid.

It means if user check today with PropertyID are paid and unpaid . and if user select any other period date , so he can know on that date,

Which PropertID are paid and Unpaid...

Kindly help me on the same..

[sunny_talwar]

But how will this change if user select another date? Can you check if this is what you are looking for?

Expression:

=Only({<Date>}Aggr(If(Avg({<Date>}start_datetime) <= Only(TOTAL Date) and Avg({<Date>}end_datetime) >= Only(TOTAL Date), 'Paid', 'Unpaid'), PropertyID, Date))

[brijeshvma]

Hi Sunny,

i checked this ..

but thing i need in this more you can say , if i select and month its not check the start date and end date and shows all propertid as unpaid .

as well if user dont select any thing so its show those Property id as paid where today date shows in between start date and end date .

as well i want one dimension for this . to show list box as Paid and UnPaid .

[brijeshvma]

thats the reason i was trying to create in script this condition so i can have one dimension for this as well

[sunny_talwar]

Would you be able to provide the QVDs to reload the application and test out?

[brijeshvma]

Hi Sunny ,

PFA for Dummy data as w

[brijeshvma]

PFA

[sunny_talwar]

Brijesh, I am having difficulty imagining what output are you looking to achieve (back end or front end). Based on few choosen PropertyID, would you be able to guide us what would be expected output when:

1) Nothing is selected in Date?

2) When Multiple Dates are selected?

3) When a Month is Selected?

4) When only a single date is selected?