Hi!, is it possible to bring the records created before a specific time in a data set? (bearing in mind that the date will always be different)
n
Netsuite Tragic
03/10/2022, 5:25 AM
tell us more of what you need. For a relative time I use a criteria which includes ({now}-{datecreated} )* 24 which will give you a decimal number of hours since the record was created.
Netsuite Tragic
03/10/2022, 5:28 AM
For records created before 6am I would start with TO_CHAR({datecreated},'H').