Unanswered: using IIf statements in report then sort..
I post this before, did'nt get a reply so I will ask differently.
Using this expression from a query to pull within a range of dates using a field with both date and times.
Like;GroupDate: Format(DateAdd("d",IIf(([startdatetime]-Int([startdatetime]))<0.25,-1,0),[startdatetime]),"Long Date") in ascending order from the query it's sorts correctly. But it will not sort in ascending order using a report as the "GroupDate" will be the grouping field.
I tried this, still my records not sorting by date. They are sorting by weekdays like; Friday, Monday etc. I need to sort like from a range when I input 01/01/04 to 01/31/04 sorted by my entry. But still show my format "Long Date".
One thing that you could try is add another field in your query which is the exactly the same date that you want to sort on without the formating to long date. Add the field to your report and set it's Visible property to False. Then do the sorting on this field.