Flagging records as NEW and OLD

[manisharora]

Hi All,

I am stuck in a scenario where I have to flag the IDs as New Or Old based on the time stamp.

But the tricky part here is that I have to flag a particular record new for the complete whole month when that transaction is made.

I have used this script and I am able to achieve my requirement at the front end using this

expression =if(YearMonth1= AGGR(MIN(FirstDate),FMONTH),'NEW','OLD')

but It's required to be done in the script only.

Please refer the snapshot.