Skip to content

Is it possible to create a custom field that's just a sortable TRUE/FALSE value, based on whether another date column on the same record is earlier than the current date (sysdate)?

Answer

Yes — create a read-only custom field using a Select Statement with a CASE expression, for example: SELECT CASE WHEN (relevant_date_column < SYSDATE) THEN 'TRUE' ELSE 'FALSE' END FROM your_table WHERE your_key_columns = :bind_variables. Define the bind variables in the custom field's SQL Arguments to match the record's actual key columns, and the resulting field will show and sort as a plain TRUE/FALSE value driven by that date comparison.

← Browse Developer Studio, deployment, and upgrades questions