Tracking "new" instances using previous command - help !!

[#1]

Hi,

I am trying to identify which concepts have newly appeared at which start_period.

Kindly have a look at the snapshot which covers both the front (table box) and the back end script.

Ex: The "zein" concept though it is OLD it is marked as NEW. Kindly help . and the backend script.

[swuehl · Accepted solution]

I assume your issue is because you create your Start_Period values as text values, then sort ascending in your second load, while you probably assume a chronological sort. Try

Monthname(Start_Period) as Start_Period

for now.

[#3]

Thanks Swuehl,

That worked like charm.