How to parametrize the date expression

[zwyne]

Hello there,

I would like to put parameters in my date variables , below are my expressions

vSetMTD             =Year={'$(vMaxYear)'},Month={'$(vMaxMonth)'},Day={'<=$(vMaxDay)'},Date=,MonthYear=
vSetPreviousMonth   =Year={'$(vPriorMonthYear)'},Month={'$(vPriorMonth)'},Day={'<=$(vMaxDay)'},Date=,MonthYear=

eCntFlgCurr  =  count({<$(vSetMTD)>}Flags)

eCntMajCurr  =count({$<Flags={'MajFlagTrc'},$(vSetMTD)>}Flags)+ count({$<Flags={'MajFlagPipe'},$(vSetMTD)>}Flags)

eCntMajCurr% =num(($(eCntMajCurr))/$(eCntFlgCurr),'#0.%')

Thanks

[marcus_sommer]

What do you meant with parametrize the date expression?

I don't know your data and requirements and your approach might be sensible but for me it looked like an overusing of variables because they have the aim to simplify things and here I'm not sure they does.

- Marcus