Current Date/Time Fields

Does anybody else here struggle using current date/time? I am trying to create reports that will only display records created say “today” or “yesterday”. I’ve also found that when you format a date as mm/dd/yy it seems to recognize it as text instead of a true date. I find myself using expressions like this sometimes to work around the issue: