Calendar object is not selecting the correct date range

[fashid]

Hi Experts,

I am working on the canonical date concept in my application and i have created 2 master calendars for the same table .

One calendar works for filtering on the ENQ_DATE and the second calendar works on QUOTE_APPROVED_DATE.

In my app on the first sheet i am trying to use the FROM and TO date filter to work on the ENQ_DATE column in my table box , which works as expected .

Now on the second sheet i am trying to implement the same concept on the QUOTE_APPROVED_DATE column but somehow the filters

fail to work .

Could someone point out what the issue could be .

Regards,

Nadeem

[fashid]

i am also attaching the sample QVD for the app

[MindaugasBacius]

Check the connection of the field CALENDAR_QUOTE.CalendarDate. It have no values.

[fashid]

Hi

Thanks for the reply Mindaugas ,but i cannot use the QUOTE_APPROVED_DT as it will not give me an entire range of dates(Missing dates in the QUOTE_APPROVED_DT field) .

If you see the first sheet the CalendarDate field correctly works for the ENQ_DATE .

I am just trying to replicate the same with a different calendar and different field name in the second sheet ,but somehow its not working .

Regards,

Nadeem

[MindaugasBacius]

As I mentioned the field CALENDAR_QUOTE.CalendarDate is empty while CalendarDate is properly connected:

That's the main reason why you do see information in Sheet1 while in Sheet2 it do not work.

[fashid]

Now even after disabling the first calendar the field is not getting mapped .

Is there some issue in my script ??

[fashid]

Hello can anybody please help on this issue