Calendar issue

[bobbydave]

Hi.

Once upon a time, we have a calendar application and another application had a fiscal calendar and now the fiscal calendar is the main app and I am trying to integrate the calendar year application into the fiscal application.

But my calendar is not connecting even though it shows in the design.

Anyone any ideas.

On the front, once compiled, the Date field should load.

It does in my real application but when bringing in the calendar year application, it aint.

Any ideas appreciated.

[bobbydave]

Anyone?

[marcus_sommer]

At the moment I couldn't look into app but I think this will be very helpful for you: How to use - Master-Calendar and Date-Values

- Marcus

[MarcoWedel · Accepted solution]

Hi,

I guess the "CallsDate" field ("Calls.Date" field in your A_Call.qvd) and your "FiscalYearPeriod" field in T_Calendar.qvd do not contain matching values, thus "Where Exists (%FiscalYearPeriod, FiscalYearPeriod);" will never be true.

regards

Marco

[bobbydave]

You are right.

My main application has dates coming in in fiscal month year format YYYYMM from the QVD.

The part I am trying to bring in (the qvw that I attached) from the QVD is DD/MM/YYYY. I am going back to that loader now and changing it to Fiscal Year Month format so that when I load it now, it will be in Fiscal format from the start.

Thanks for the advice and the help.

Much appreciated.