Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends,
how to pass a particular date value in expression.
i need to pass every year last date.i.e; 31Dec2013, 31Dec2012 where i used today() in the below expression.
=(if((CLM_STATUS <>'C' or (CLM_STATUS='C' and Today()<=CLM_CLOSE_DT))and CLM_STATUS<>'R' and (CE_CLOSE_YN <> '1' or (CE_CLOSE_YN= '1' and CE_CLOSE_DT>Today())),
(sum({<CS_EST_TYPE={"=CS_EST_TYPE=1"},CE_DT={"=CE_DT<=Today()"},CE_PARTY_ID={"=CE_PARTY_ID=CS_PARTY_ID"},CLM_TRANS_ID={"=CLM_TRANS_ID=CE_CLM_TRANS_ID"},CS_CLM_TRANS_ID={"=CS_CLM_TRANS_ID=CE_CLM_TRANS_ID"},CE_EST_SR_NO={"CE_EST_SR_NO=CS_EST_SR_NO"},CLM_COMP_CODE={"=len(trim(CLM_COMP_CODE))>0"},CE_EST_SR_NO={"=len(trim(CE_EST_SR_NO))>0"},CS_PARTY_ID={"=len(trim(CS_PARTY_ID))>0"},CE_PARTY_ID={"=len(trim(CE_PARTY_ID))>0"}>}CS_AMT_LC_1)
-
(sum({<CS_EST_TYPE={"=CS_EST_TYPE=3"},CE_DT={"=CE_DT<=Today()"},CE_PARTY_ID={"=CE_PARTY_ID=CS_PARTY_ID"},CLM_TRANS_ID={"=CLM_TRANS_ID=CE_CLM_TRANS_ID"},CS_CLM_TRANS_ID={"=CS_CLM_TRANS_ID=CE_CLM_TRANS_ID"},CE_EST_SR_NO={"CE_EST_SR_NO=CS_EST_SR_NO"},CLM_COMP_CODE={"=len(trim(CLM_COMP_CODE))>0"},CE_EST_SR_NO={"=len(trim(CE_EST_SR_NO))>0"},CS_PARTY_ID={"=len(trim(CS_PARTY_ID))>0"},CE_PARTY_ID={"=len(trim(CE_PARTY_ID))>0"}>}CS_AMT_LC_1)))))
please anyone suggest me how to resolve this issue
Thanks & Regards
Krishna
Hi,
Replace today() with YearEnd(today())
Make sure to format date as required.
Regards
ASHFAQ