CASE WHEN {custrecord_npo_grant_end_date} - {today} BETWEEN 0 AND 90 THEN TRUE ELSE FALSE END Do I use formula date, formula text or formula numeric to insert this statement? How come I cannot submit the field after pasting this formula?

AI generated answer (using internal Slack threads):

The formula you're trying to use is a conditional statement that checks if the difference between a custom field

custrecord_npo_grant_end_date

and the current date is between 0 and 90. If it is, it returns TRUE, otherwise it returns FALSE. This formula should be inserted as a Formula (Numeric) because it's comparing the difference between two dates (which is a numeric value) and returning a boolean value (TRUE or FALSE). If you're having trouble submitting the field after pasting this formula, it could be due to a few reasons: 1. There might be a syntax error in your formula. Make sure all parentheses and brackets are correctly placed and that all field names are correctly spelled and formatted. 2. The fields you're referencing in your formula might not exist or might not be accessible in the context where you're trying to use the formula. Make sure the

custrecord_npo_grant_end_date

field exists and is accessible. 3. The formula might be too complex or might be causing a calculation error. Try simplifying the formula or breaking it down into smaller parts to identify the issue. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******