AnsweredAssumed Answered

Expired this month

Question asked by thong127 on Oct 20, 2014
Latest reply on Jan 23, 2015 by thong127

Title

Expired this month

Post

Hello All,

Please help me with my problem below

I have a 2 tables

1. Dashboard (Fields below):

Field Name                                           Type                                       Comments

a) Constant today                                      Calculation                      Get ( CurrentDate )

b) Expiring this month                                Calculation                     Let (

[AlertCount = Count ( Dashboard::id_constant ) ] ;

Case (

AlertCount = 0 ; TextColor ( "0" & " Material expiring today! " ; RGB ( 120 ; 120 ; 120 ) ) ;

AlertCount = 1 ; TextColor ( AlertCount &  " Material expiring this month! " ; RGB ( 0 ; 136 ; 0 ) ) ;

AlertCount >1 ; TextColor ( AlertCount &  " Materials expiring this month! " ; RGB ( 220 ; 0 ; 0 ) ) ;

)

 )

c) id Constant                                             Calculation                            1

2. Materials 

Field Name                                                    Type                                    Comments

a) Expiry Date                                                Date

b) ID Constant                                                 Calculation                             1

 

The two tables are connected by a relationship id Constant = ID Constant and Constant today = Expiry Date

Now, my problem is I want to get the number of materials that expiring this month using the field Expiring this Month from my Dashboard Table.

Any help is highly appreciated

Outcomes