Year to month Stutus Update issue

[Anonymous]

Hi,

I have fields like CustID ,year , month and status  .status field contains every year status update of CustId if I click on CustID the status of that custuid will be displayed with currentYear .If any custID has no satus in this year(means only 2015) it will display last year status(ie 2014) ,in prev year also no status update for that custID it will display 'NO Status'.in every year status will be updated on June month .Can any one please help me how to write a expression for this.

Thanks in Advance.

[jagan]

Hi

Try this expression

=Alt(Only({<Year={$(=Year(Today()))}>} Status), Only({<Year={$(=Year(YearStart(Today(), -1)))}>} Status), 'No Status')

Hope this helps you.

Regards,

Jagan.

[Anonymous]

Thankyou jagan,

But every year june status will be updated so we have to write condition for that.

[jagan]

Hi,

Can you attach sample data and your expected output?  It would be easier to understand and give solution easily.

Regards,

Jagan.

[jagan]

Hi,

Create a variable like below

vCurrentStatusYear = If(Today() >= MakeDate(Year(Today()), 6), Year(Today()), Year(Today()) - 1)

=Alt(Only({<Year={$(=vCurrentStatusYear)}>} Status), 'No Status')

Hope this helps you.

Regards,

Jagan.