Date format - I need a saved search to return a date with leading zeros, but get 3/3/2019 no matter what I do. The date format in Setup=>Company=>General Preferences is M/D/YYYY. Is there any way I can override that with a formula?

Have you tried your personal date preferences?

They are grayed out, I can't change it.

Formula (Text)

TO_Char({trandate},'MM/DD/YYYY')

?

Oh, geez - I was using TO_DATE, this did the trick. Thanks!

Blame it on Monday morning. 😀

I will, and a Monday after a time change - double whammy!