I found this thread while looking for an answer to how I need to format a static date in a calculated field. Short answer is DATE ("YYYY-MM-DD") e.g. DATE("2023-03-23") or DATE("MM/DD/YYYY") e.g. DATE("03/23/2023").
For my use case I needed an IF statement that would return a text string if a cust...