Concatenation of field with mastercalendar

[beck_bakytbek]

Hi Folks, i have a question, my business situation does look like:

I have a Mastercalender with following Fields and Values:

Year = 2018

Year Month = 2018 02,

And i have a separate table with fields: Date_of_Status, this Field consist of information when my project expires : for instance

Project, Date_of_Status:

Project A, 05.06.2017

Project B, 06.05.2018

Project A, 12.12.2017

My Issue is: how can i concatenate this Field with my mastercalender, i am pursuing a goal where if i select my mastercalender and if my Value from mastercalender is large then the value from Field: Date_of_Status then should be created a additional field: for instance: Active and Not active:

Calculation and logic does look like: if i select my calendar

Mastercalender     Value from Field: Date_of_Status        Status            Explanation

2018 02                            06.05.2018                          activ              (here is my project active, because: 06.05.2018 > 2018 02)

2018 02                            05.06.2017                          not active       (here is my project non active, because: 05.06.2017 < 2018 02)

if this logic is done, i want to create the filter: Status : active and non active, So i can select all active and non active project in depende of my master calendar.

Does anybody have any idea? if my explanation not clear enough, please let me know

Thanks a lot

Beck

[YoussefBelloum]

Fortunately I can still read in my native language

[zebhashmi]

don't you think simple if the function will work for that?

[beck_bakytbek]

Hi Hashmi,

what do you mean by that? Do you have any idea?

[zebhashmi]

I was just thinking like that

if(Monthyear>ProjectstatusDate,"Active","Not Active")

sorry if I am just passing it without depth.

[beck_bakytbek]

Hi Hashmi,

no problem, each idea is welcome, you can take a look into attached example