Using Format expresstion for date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

H
I have a qurey which uses fotmat(date1,"mmm yy") when I ran this query, I got results as DEC 03, Feb 04, Jan 04. My Question is how I can display data as Dec 03, Jan 04, Feb 04

I appriciate your help
 
Hi,

The order is not right? If so, add an order by clause, to your
query: ORDER BY date1 ASC


Hoping it may help,
Vanderghast, Access MVP


Nilesh BUtala said:
Hi
I have a qurey which uses fotmat(date1,"mmm yy") when I ran this query, I
Click to expand...
got results as DEC 03, Feb 04, Jan 04. My Question is how I can display data
as Dec 03, Jan 04, Feb 04?
 
Back
Top