I agree, unfortunately I do not think that is an option I have at my disposal.
We are using software that uses SQL. It has a built in Report feature, with a built GUI criteria section. On the Criteria section, it allows you to enter a date and it will compare the date entered to any field or variable you designate (what I am trying to create).
99% of the time, users are going to want to see the records posted today or yesterday (but only on one day), so they are going to select the "Equals to" option and enter their date. They are not very computer savvy, so I really can't ask them to use things like Greater Than (which wouldn't work anyway if they ONLY wanted to see Yesterday, or some other past day's postings).
So, if every date in SQL has a time component (which I think it does), then I believe I just need to convert the Date/Time Stamp to change the time piece to 0:00? Does that sound right?
The question is how?