I am new to this forum and perhaps I phrased my question poorly.
I am looking for the correct function statements that will mean "Yesterday at 12:00:00 AM" and "Today at 12:00:00 AM" so I can schedule a report to run every morning without manually changing the dates. The data element I am using in this particular universe is "appointment date/time".