Need to find New record for the specific date or is it a existing record from yesterday

[MS90]

 I want to Create  a new field which identifies if a record  is a  New record for the specific date or is it a existing record from yesterday 

 

[QFabian]

@MS90 , here you have one script option  :

Data:

Load * Inline [

Order No, ID NO, Start Date

1, AZ, 8/8/2024

2, AY, 1/8/2024

3, ZC, 02/8/2024

4, VB, 5/8/2024

5, RE, 7/8/2024

6, FI, 10/8/2024

];

New_Field:

Load

[Order No], 

    if([Start Date] = today(), 

'Todays Record',

if([Start Date] < today(),         

    'Past Record',

        'Future Record')) as New_Field

Resident Data;

exit script; /*

[MS90]

Thank you,

But I can't do this on date field I need to do this on Idno