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

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

MS90 — Fri, 15 Nov 2024 20:53:47 GMT

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 — Thu, 08 Aug 2024 17:45:25 GMT

@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 — Mon, 19 Aug 2024 18:25:30 GMT

Thank you,

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