Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Val Exp Comparing Month and Year Part Only

Status
Not open for further replies.
GreatDreamer

GreatDreamer

Programmer
Feb 11, 2006
15
CA
I have added the following in Value Exp for one of the controls:

(Sum( [M_R_CAP_TDY] ) Where ([M_BASE_M] <[M_MAT_DT]))/1000

What I would like to do is just compare the MONTH and YEAR part only.

I.E:

(Sum( [M_R_CAP_TDY] ) Where (Month[M_BASE_M] < Month[M_MAT_DT] and Year[M_BASE_M] <= Year[M_MAT_DT] ))/1000

Does anyone know how to do this?
 
Status
Not open for further replies.

Similar threads

tito123_
  • Locked
  • Question
printer printing only copy
Replies
0
Views
144
tito123_
tito123_
hmax
  • Locked
  • Question
Actuate BIRT Designer Professional - Select statement with Case and Like clause
Replies
0
Views
120
hmax
hmax
seba991
  • Locked
  • Question
Actuate 11 - ROI crashes (corrupted ?), but only when TOCNeeded option is set to &quot;Yes&quot;
Replies
0
Views
95
seba991
seba991
aashish4maximo
  • Locked
  • Question
Trying to make multiselection value enabled input parameter in Actuate+Maximo
Replies
0
Views
107
aashish4maximo
aashish4maximo
riad12
  • Locked
  • Question
Pager Footer only on the last page
Replies
0
Views
75
riad12
riad12

Part and Inventory Search

Sponsor

Back
Top