Finding records within a certain time interval
Is there a way to find records in a table via scripting that have a date column value greater than a value (as opposed to just equal to it as the method seems to work now)?
Alexandru Palade
shared this idea
1 comment
-
Alex
commented
Hi Alexandru,
Depending on the use case, you can find records in a given interval using a filter or even a calculation. App scripting may not be the best use case as they only run when records are edited and not based on the passage of time as where a filter or calculated field will.
For example, the filter would look at the date as After or Equal to AND Before or Equal to...the date field. A Calculation would look something like this:
if( and( {Date} > "YYYY-DD-MM" , {Date} < "YYYY-DD-MM",1,0) You can then filter the records where "1" is present to see the records within the given time frame. You can hard code in a date, "YYYY-DD-MM", or insert a different date field from your table.
Hope this helps.
Regards,
Alex