# 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,

I have a 2 tables

1. Dashboard (Fields below):

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

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