Anyone ever mess with formulas for default values? I have a date/time field I'm trying to auto populate with today's date and 12:00 am. I have it populated with to_date({today}, 'MM/DD/YYYY'), which works in a saved search....but the field is blank when creating a new record. Not even an error....just blank

It takes a script to store the results of a formula in a custom field.

It does? Whats the point of offering a formuia checkbox then?

you can display calculated values on records, but not store them.

Gotcha. Just wrote a quick workflow to take care of it.