Previous Thread

8/7/2006 10:47:15 AM    Re: sql in access with date format
Order it by the date itself, not by the Format()'d date. 
 
Rob



8/7/2006 5:26:10 PM    sql in access with date format
hi. 
 
i want to group by  date field and display it in format of dd/mm/yyyy. 
 
the problem is when i use the order by  Format([dateCreate],"dd/mm/yyyy"), 
 
its not order by real date. 
 
any solution for that ?